HI, Rajan its working that's what I exactly want to do.
Thanx Buddy
Regards,
Muneer,
CC
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Probl
Thank a lots Asa, working very nice without any trouble.
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 7:39 AM, Asa Rossoff wrote:
> Hi Aamir,
>
> How about this:
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Application.EnableEvents = False
>
> MacroMillion Target
>
>
Very good, glad that was what you needed. :)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Siraj Momin (BTG)
Sent: Saturday, May 19, 2012 7:58 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Row to repeat at the bottom of each pa
Hi Asa
Yes I did the same, I copied the content in paint saved as a bmp file
and attached in the footer and its working fine thanks
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff
Sent: Friday, May 18, 2012 12:19 PM
To: excel-
Hi Aamir,
How about this:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
MacroMillion Target
Application.EnableEvents = True
End Sub
Private Sub MacroMillion(ByRef Target As Range)
Const M As Double = 100
Const EvalMethodMinCellThres
Shelly Murray, PHR
Manager, Labor & Workforce Planning
East Alabama Medical Center
2000 Pepperell Parkway
Opelika, AL 36801
P 334-528-1355
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of bwo...@cox.net
Sent: Saturday, May 19, 2
Maries wrote:
> TO UNSUBSCRIBE
>
> Google Groups help on the subject:
> http://support.google.com/groups/bin/answer.py?hl=en&answer=46608
>
> Key points thereof:
>
> Leave the group by any of these methods:
>
> · Reply to any group email and change the subject to "REMOVE ME"
>
For example I insert the column in sheet it's taking too much time when
running this code otherwise inserting the column is too fast. Therefore I
ask you people for look & amend for this code.
Regards,
Aamir Shahzad
On Sat, May 19, 2012 at 6:37 PM, Rajan_Verma wrote:
> *Can you make it more cle
Are your Payslips saved in a particular folder?
What is the pattern of Payslips names?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of renuka chari
Sent: 19 May 2012 4:57
To: excel-macros@googlegr
Sample file??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cute Awesome
Sent: 19 May 2012 6:13
To: excel-macros@googlegroups.com"
Subject: Re: $$Excel-Macros$$ help in matching data in excel sheet
Can you make it more clear??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 19 May 2012 6:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert amount to Million
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 19, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert amount to Million
Dear Group,
Following macro is working fine but when run this code, Inser
You need to make this clear
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Saturday, May 19, 2012 7:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the number missing in other cols
Dear friends,
I have a set of
=RANK(C2,$C$2:$C$55)+SUMPRODUCT(--($C$2:$C$55=C2),--($A$2:$A$55-Original Message-
From: Dhananjay Pinjan
Sent: Saturday, May 19, 2012 6:12 AM
To: excel-macros
Subject: $$Excel-Macros$$
Dear All,
I have used Rank Formula for ranking (pl. refer attachment). But if
Highest Column reflects
> -
>
> i am having data of sale value derived from sales sheet for over
> 3200 pieces
>
> the same has been taken in two different excel sheet by two guys but when
> we try to match sale value its not matching wheres pieces ref is matching.
>
how i can match sale value to remove the difference i.e
Dear friends,
I have a set of cols called A B C & D can please help me to solve the
issue..
Note: please check the attached copy for further understanding.
Regards,
Muneer,
CC..
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
http://www.4tops.com/mailmergeemailpdf.htm
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for
outlook emails sending Specific Templet With
Look in the help index for TRANSPOSE.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anand Kumar
Sent: Saturday, May 19, 2012 1:50 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Converting from a single column to different rows
Hi,
I have a data
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:32 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for
outlook emails sending Sp
-
i am having data of sale value derived from sales sheet for over
3200 pieces
in two different excel sheet but the same data is matching having a
difference of over 2500.
example
in sheet A the data contains
Date sale sheet no pieces reference sale value
in other sheet B
pieces referen
Can you send the sample file
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Cute Awesome
Sender: excel-macros@googlegroups.com
Date: Sat, 19 May 2012 17:38:06
To: excel-macros@googlegroups.com\"
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help in mat
i am having data of sale value derived from sales sheet for over
3200 pieces
in two different excel sheet but the same data is matching having a
difference of over 2500.
example
in one sheet the data contains
Date sale sheet no
--
FORUM RULES (986+ members already BANNED for violation)
1)
If you want With Attachments formats of word and html it would be possible.
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for
outlook
If you want With Attachments formats of word it would be possible.
From: renuka chari
To: excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 4:57 PM
Subject: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook
emails sending Spec
Hi rajan thanks for ur replay
but i need not like that
2 payslips are sending to 2 employees individually in at a time
how is it possible?
On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote:
>
> Dear experts
>
> Excel macro for sendin outlook emails from Specific Temp
Dear All,
I have used Rank Formula for ranking (pl. refer attachment). But if
Highest Column reflects 2 same value (in following example 104) it
should have to consider lower weight (Column A) & should have to give
first rank to him. The expected answer is as follows.
Weight NameHighest Ran
Try
Sub import()
Dim wkb As Workbook
Dim z As Long
Dim flpath As String
Set wkb = Workbooks.Open(Application.GetOpenFilename("Excel File
(*.xls*)," & "*xls*"))
z = ThisWorkbook.Sheets(1).Range("a65356").End(xlUp).Row + 1
ThisWorkbook.Sheets(1).Range("a" & z).Value = wkb.Sheets(1).textbox1.Value
Th
Recruiter- ma...@theglove.co.in
-- Forwarded message --
From: The Glove Consultants
Date: Sat, 19 May 2012 15:15:28 +0530
Subject: An opening from Bank of America-Gurgaon.(Report preparation)
To: koul.ash...@gmail.com
The sender of this email is registered with Naukri.com as
Can you share the sample data
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "B.N.Chethan Kumar"
Sender: excel-macros@googlegroups.com
Date: Sat, 19 May 2012 15:35:26
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help with PPT
Dear friends,
Do we
Dear friends,
Do we have any macro which will automatic will update slide in PPT with
same size and shape. If it is possible, please help with it.
--
B.N Chetan kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pl
Dear Team
Needs your support. Please find attached two workbooks, description are as
follows:
1. *AMR FORM* - that I used to received from different locations.
2. *Database *- that is the database to store data from *AMR FORM* workbook.
I want the macro code in the *database* sheet linked to
click on review protect sheet
Uncheck all options and click on ok ( Note worksheet password are not much
secure. You will find lot of free add-ins on google to break the sheet
protection).
[image: Inline image 1]
vba try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
Regards
can you share the sample data
On Sat, May 19, 2012 at 12:20 PM, Anand Kumar wrote:
> Hi,
>
> I have a data set where Name, Address, STD Codes, Phone Number, Mobile No.
> all are in a single column for different people. I want to have names in
> first column, Address in next column and std codes
33 matches
Mail list logo
