Re: $$Excel-Macros$$ SUM

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

For summing col 5,6,7 i enclose the code. verify. do it for sny no. of 
sheets.the code follows:Sub sum567()
Dim LastRow As LongDim iRow  As LongDim iCol As IntegerLastRow = 0
For iCol = 5 To 7  iRow = Cells(65536, iCol).End(xlUp).Row  If iRow > LastRow 
Then LastRow = iRowNext iCol
With Application.WorksheetFunction  For iRow = 1 To LastRow    Cells(iRow, "h") 
= .Sum(Range(Cells(iRow, "e"), Cells(iRow, "g")))  Next iRow    For iCol = 5 To 
7    Cells(LastRow + 1, iCol) = .Sum(Range(Cells(1, iCol), Cells(LastRow, 
iCol)))  Next iColEnd With
    
End Sub

  From: Izhar 
 To: excel-macros@googlegroups.com 
 Sent: Sunday, May 22, 2016 8:57 PM
 Subject: $$Excel-Macros$$ SUM
   
in the attachment I have two sheets i.e. JAN & FEB, in both the sheets data are 
same but in the FEB sheet it is more than the JAN sheet, i need a macro when I 
run it, the macro sum column E,F,G, in JAN with the heading TOTAL and in the 
same way when I run the same macro it sum the the said column of FEB sheet and 
in future if we have more data the above macro sum the same column of the new 
data in the same way as it sum the above 
THANKS IN ADVANCE


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


macro for sum240516.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

Hi,I give u the following code you can run and get what u expect. For the next 
time u have to change the j value(i.e.,columnvalue,A=1 B=2 etc) to 6 to 7, and 
next time this should be 8 to 9.Or if u don't mind in over printing the data,u 
can put j value = 4 to 33.It is upto u.Here the row is fixed to 15 i.e., i value
Sub FillSheet1To2()Dim i, j As Integer For i = 1 To 15    For j = 4 To 5        
        Sheets("sheet2").Cells(i, j).Value = Sheets("sheet1").Cells(i, j).Value 
             Next j  Next i   End Sub
-r.Karunanithi.

  From: Kat 
 To: MS EXCEL AND VBA MACROS  
 Sent: Thursday, February 4, 2016 1:07 PM
 Subject: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2
   
Hi all,

I have a workbook in which the row is fixed (eg. from column A to C) and the 
user will keep adding new column (eg. from adding data in Column D to E first 
time, second time adding data in column F to H) in Sheet 1. Everytime when new 
column is added in Sheet1, I want it to be automatically being copied and 
pasted into Sheet2 as well starting from Column F. For instance, When user add 
data in Column D to E first time, then the data being added in Column D to E in 
Sheet1 will be automatically being copied and pasted in Column F to G in 
Sheet2. Can anyone help?

Thanks in advanced.
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


FillSheet1To2.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ compare columns through for loop

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

Hi,I enclose which may solve ur request.
 

  From: Kat 
 To: MS EXCEL AND VBA MACROS  
 Sent: Wednesday, February 3, 2016 6:28 AM
 Subject: $$Excel-Macros$$ compare columns through for loop
   
Hi all,

I would like to compare columns in two workbooks. If data from column D in 
fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If they 
are not matched, then data from column A to C in fortest1.xlsx needs to be 
copied and pasted to column C to E in tested.xlsm. Please see attached for the 
file. 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


CompareColomn322016.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Autofill Macro

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

Hi,
Keep the cursor in A1 and run the following code. Here I put the autofill 'C' 
column and you will get the required result.
File also enclosed.
 
Sub autofill()
    Do While ActiveCell  
  ActiveCell.Offset(0, 2).FormulaR1C1 = ActiveCell.Offset(0, 0)
  ActiveCell.Offset(1, 0).Select
    Loop
End Sub
 
On Saturday, May 10, 2014 11:32 PM, Vaibhav Joshi v...@vabs.in wrote:
  
Cheers!!



On Sat, May 10, 2014 at 11:05 PM, Bill Q ronsmith...@gmail.com wrote:

Perfect ! Thanks very much Vabz.


On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz  wrote:
Hi


See attached file.. Hope this is what exactly i want, i guess i am getting 
what you mean by autofill.. 


Cheers!!



On Sat, May 10, 2014 at 8:44 PM, Bill Q ronsm...@gmail.com wrote:

Hi Guys, 


Thanks for your replies. I should have attached a sample spreadsheet for 
illustration  clarification purposes. Please see attached. 


Very simply - whatever is in A1 is to go into B1 identically - the 
autofilled all the way down until it no longers encounters any data in A. 


Thanks.  

On Friday, 9 May 2014 20:50:55 UTC-4, Bill Q  wrote:
I have spent the better part of 40 minutes searching the web for what I 
believe is a simple solution. I have found many answers. I have tried them 
all - None are working to what I am looking for. 


Simply put.


- Assume source Data is always is column A. It could be 50 rows in length 
or 84,679 rows in length. 
- The data in the rows in column A will always be different. 


I simply want a macro that will autofill starting from B1 until it 
encounters no more data in column A
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups 
MS EXCEL AND VBA MACROS group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an 
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from 

Re: $$Excel-Macros$$ How to Drag get C,D,E,F post A,B...

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

Hi,
If you want in columns, say a1,b1,c1 etc use the following fomula(which I 
learned from this site) and drag it (UPTO Z).
 
=MID(ADDRESS(1,COLUMN()),2,1) 
-r.karunanithi.
On Friday, May 9, 2014 1:20 PM, Amit Desai (MERU) amit.de...@merucabs.com 
wrote:
  
Dear Abhishek, 
  
This worked perfectly fine. Thanks a lot. 
  
I just check how Left  Address formula works! Could you please explain me how 
does the formula works? 
  
Regards, 
Amit Desai 
  
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Abhishek Jain
Sent: 05-Fri-2014 12:34
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ How to Drag  get C,D,E,F post A,B...  
  
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this, 
you can use below after putting A in A1 - 
   
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)26)+1)  
   
Regards, Abhishek  
  
On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU) amit.de...@merucabs.com 
wrote: 
Dear Friends, 
  
Please help me with very basic query. 
  
When we have 1 in Cell A1  2 in Cell A2, when we drag the data further down 
selecting both cells, we get 3,4,5,6,7 etc 
  
However when we do this for cells with A in Cell A1, B in A2, we do not get 
C,D,E,F...Any logical Reason? Is there any method to get this done in Excel? 
  
Regards, 
Amit Desai – MIS Manager 
M: +91 9867232534 
    
   
Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.   
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.  
    
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the 

Re: $$Excel-Macros$$ Autofill Macro

['karunanithi ramaswamy' via MS EXCEL AND VBA MACROS]

 Hello, what is to be autofill. can u give what is in a1 to a5 and 
what is to be autofilled in b1 to b5
-r.karunanithi.
On Saturday, May 10, 2014 6:20 AM, Bill Q ronsmith...@gmail.com wrote:
  
I have spent the better part of 40 minutes searching the web for what I believe 
is a simple solution. I have found many answers. I have tried them all - None 
are working to what I am looking for.

Simply put.

- Assume source Data is always is column A. It could be 50 rows in length or 
84,679 rows in length. 
- The data in the rows in column A will always be different.

I simply want a macro that will autofill starting from B1 until it encounters 
no more data in column A
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Date of Retirement.

[karunanithi ramaswamy]

Hi,
Use 'End of month' formula and add 720or whatever number of months to find
the date of retirement.(Usually retirement happens at the last day of the month)
- r.karunanithi.



On Wednesday, February 19, 2014 4:29 PM, prabhakar_k...@sify.com 
prabhakar_k...@sify.com wrote:
  
thanks its working fine
On Tuesday, February 18, 2014 9:59:44 PM UTC+5:30, Mahesh wrote: 
Hi Prabhakar 

 
perhaps you can use, 
=DATE(YEAR(H2)+60,MONTH(H2), DAY(H2)) 

 
Regards 
Mahesh 



On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara ashishb...@gmail.com wrote:

Dear Prabhakar, see the attached file to know the retire age as per your 
example 



On Tue, Feb 18, 2014 at 2:50 PM, prabhak...@sify.com wrote:

Hi Team, 

I need your help to find out date of retirement with simple formula in 
attached excel file.
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups 
MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an 
email to excel-macros...@ googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




-- 

Regards. 
Ashish Bhalara 
9624111822 
PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.♣♣♣ 

 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an 
email to excel-macros...@ googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 

$$Excel-Macros$$ $$How to FillDown using offset-macro required

[karunanithi ramaswamy]

Sirs,
   I want to fill down Sim card numbers around 5 lacs each contain 19 digits
and the sims have numbers from one value to another, in sequence for 5 to 
10,000.
I split this to 3 or 4 columns and then idea to concatenate.  The numbers in 
sequence
is highlighted in yellow.Using a macro i can make the Data to Required Data, 
except
the hilight area.I can make duplicate entries using the macro.
  I request you experts, get me a macro to add one number more than the above 
cell
in highlighted column for each sequence and for all the rows in sequence.Sample 
file
is attached.
  Thank u in advance.
R.Karunanithi
919486100934.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




FillDownRK.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

[karunanithi ramaswamy]

Sir,
   I have data of Station and category in columns a and b.  But  I want the 
report
in category wise as in columns h to k.  When i use the sumproduct formula it 
works
and it is not working in vba. Please guide how to modify the vba to get the 
desired
result.(formula used is available in the worksheet)
- R.Karunanithi

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




sumpro1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

[karunanithi ramaswamy]

Hi,
  Pl see the attached sheet.(you can also find the days between two dates)
  -R.Karunanithi.
 


 From: MRafique Ujjan imrafiqu...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Monday, November 26, 2012 4:48 PM
Subject: $$Excel-Macros$$ How to calculate Joining Date from a given job 
period!!!
  

Dear All Excel Experts:

I am having a following problem.

I am given only total working days of an employee like 2 years 5 months  13 
days
Now i am asked to calculate joining date of each employee.

Therefore, i need your help in this regard I hope u will help me as this group 
helped me earlier. For any clarification please feel free to ask me. 

Thanks in advance

Muhammad Rafique Ujjan 
-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




joindate.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

[karunanithi ramaswamy]

Hi,
   If year,month,days are in A1,A2,A3 respectively then put the date on which 
you want to calculate in A4,
enter the formula in A5(the joining date,if it is one complete spell, 
=Date(Year(A4)-(A1),Month(A4)-(A2),Days(A4)-(A3))
   R.Karunanithi



 From: MRafique Ujjan imrafiqu...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Monday, November 26, 2012 4:48 PM
Subject: $$Excel-Macros$$ How to calculate Joining Date from a given job 
period!!!
 

Dear All Excel Experts:

I am having a following problem.

I am given only total working days of an employee like 2 years 5 months  13 
days
Now i am asked to calculate joining date of each employee.

Therefore, i need your help in this regard I hope u will help me as this group 
helped me earlier. For any clarification please feel free to ask me. 

Thanks in advance

Muhammad Rafique Ujjan 
-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ ***Compare 2 sheets***

[karunanithi ramaswamy]

Hi,
One way is finding the matching cells, by copying sheet3 in sheet1 and run the 
program.In column H Available are matching cells.Then filter
the blanks selecting upto 14 rows. you will get what you want.
  - Karunanithi R
 


 From: Prabhu prabhugate...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Saturday, November 24, 2012 4:53 PM
Subject: $$Excel-Macros$$ ***Compare 2 sheets***
  

Hi Friends,

I have to  compare two sheets and copy the unmatched rows to the 1st sheet.

Example need compare sheet3 column A in to sheet 1Column A and copy the 
unmatched items in Sheet 3 and to be pasted in bottom of Sheet 1.

Note: Need to compare Sheet 3 to Sheet 1 not Sheet 1 to sheet 3

when we copy unmatched rows from sheet3, Three Column (A,B  C) has to be 
copied and past in Sheet 1 no need to copy D

I have attached work book for the ready reference( Highlighted are copied from 
sheet 3)

Plz help

Regards,

Prabhu 

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




notmatch241112.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch error -reg

[karunanithi ramaswamy]

Dear Expert Paul Schreiner,
 
    Thank you for your remarks.  After correcting thespaces into 0,it 
works.
 
-R.Karunanithi.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch error -reg

[karunanithi ramaswamy]

Dear Shri Pal Schreiner,

I really took your different approach solution as deepavali bumber, which 
make me to know more
about Dictionary Objects and I will try to learn. This 'opening' gives me a 
great happiness.
A small key always open a big door behind it. My sincere thanks to you.
 -R.Karunanithi.




 From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com 
Sent: Friday, November 2, 2012 11:12 PM
Subject: Re: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type 
mismatch error -reg
 

Just because I was bored and wanted to play a bit.
I wrote a somewhat different approach to your macro.
I utilized Dictionary Objects for each of the readings and total values you 
were collecting.
I initialized the Objects,
then read through the data and added the values to the Dictionary Objects.
 
Then inserted the totals.
 
On my machine, your approach took 38 seconds.
 
This approach ran in .08 seconds.
(watch the editor's line wrapping)
 
if you're interested...
---
 
Sub Dict_Sum()
    Dim Dict_Reading1
    Dim Dict_Reading2
    Dim Dict_Reading3
    Dim Dict_Reading4
    Dim Dict_Total
    Dim R
    Dim tStart, tStop, tMin, tSec
    tStart = Timer
    
    Set Dict_Reading1 = CreateObject(Scripting.Dictionary)
    Dict_Reading1.RemoveAll
    Set Dict_Reading2 = CreateObject(Scripting.Dictionary)
    Dict_Reading2.RemoveAll
    Set Dict_Reading3 = CreateObject(Scripting.Dictionary)
    Dict_Reading3.RemoveAll
    Set Dict_Reading4 = CreateObject(Scripting.Dictionary)
   
 Dict_Reading4.RemoveAll
    Set Dict_Total = CreateObject(Scripting.Dictionary)
    Dict_Total.RemoveAll
    '-
    'Load Dictionary
    '-
    For R = 2 To 40
    If (Cells(R, T).Value = ) Then Exit For
    Dict_Reading1.Add Cells(R, T).Value, 0
    Dict_Reading2.Add Cells(R, T).Value, 0
    Dict_Reading3.Add Cells(R, T).Value, 0
    Dict_Reading4.Add Cells(R, T).Value, 0
    Dict_Total.Add Cells(R, T).Value, 0
    Next
 R
    '
    'Add Data
    '
    For R = 2 To ActiveCell.SpecialCells(xlLastCell).Row
    If (Dict_Reading1.exists(Cells(R, C).Value)) Then
    Dict_Reading1.Item(Cells(R, C).Value) = 
Dict_Reading1.Item(Cells(R, C).Value) + Cells(R, D).Value
    Dict_Reading2.Item(Cells(R, C).Value) = 
Dict_Reading2.Item(Cells(R, C).Value) + Cells(R, E).Value
    Dict_Reading3.Item(Cells(R, C).Value) = 
Dict_Reading3.Item(Cells(R, C).Value) + Cells(R, F).Value
   
 Dict_Reading4.Item(Cells(R, C).Value) = Dict_Reading4.Item(Cells(R, 
C).Value) + Cells(R, G).Value
    Dict_Total.Item(Cells(R, C).Value) = Dict_Total.Item(Cells(R, 
C).Value) + Cells(R, H).Value
    End If
    Next R
    
    '
    ' Paste Totals
    '
    Application.ScreenUpdating = False
    For R = 2 To 40
    If (Cells(R, T).Value = ) Then Exit For
    Cells(R, U).Value = Dict_Reading1.Item(Cells(R, T).Value)
    Cells(R, V).Value = Dict_Reading2.Item(Cells(R,
 T).Value)
    Cells(R, W).Value = Dict_Reading3.Item(Cells(R, T).Value)
    Cells(R, X).Value = Dict_Reading4.Item(Cells(R, T).Value)
    Cells(R, Y).Value = Dict_Total.Item(Cells(R, T).Value)
    Next R
    Application.ScreenUpdating = True
    tStop = Timer
    tMin = Int((tStop - tStart) / 60)
    tSec = Round((tStop - tStart) - (tMin * 60), 2)
    Debug.Print tStop  -  tStart      tMin  :   tSec
    MsgBox tMin  :   tSec
End Sub
 
 
 
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





 From: karunanithi ramaswamy era_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Fri, November 2, 2012 1:15:24 PM
Subject: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch 
error -reg


Dear Expert Paul Schreiner,
 
    Thank you for your remarks.  After correcting thespaces into 0,it 
works.
 
-R.Karunanithi.-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security

Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

[karunanithi ramaswamy]

Sir,
    This works fine.  I got what I expected.
Thanks.
Karunanithi R



 From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Thursday, April 12, 2012 12:11 AM
Subject: RE: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO 
DATES
 

See the attached file 
Try this:
 
Sub ExtractData()
    
Dim rngRange As Range
    Dim rngCell As Range
    Dim rngUnion    As Range
    Dim dtStart As Date
    Dim dtEnd As Date
    Dim rngResult   As Range
    
Set rngUnion = Range(A1:B1)
    Set rngRange = Range(A1).CurrentRegion
    dtStart = Range(rngStart).Value
    dtEnd = Range(rngEnd).Value
    
If IsDate(dtStart) And IsDate(dtEnd) Then
    For Each rngCell In rngRange.Columns(2).Cells\
    If rngCell.Value = dtStart And rngCell.Value = dtEnd Then
   Set rngUnion = Union(rngUnion, rngCell.Offset(, -1).Resize(1, 2))
    End If
    Next
    Set rngResult = Application.InputBox(Please select a Cell to paste the 
Extracted Data, , , , , , , 8)
    rngUnion.Copy
    rngResult.PasteSpecial xlPasteAll
    Application.CutCopyMode = xlCopy
   Else
    MsgBox Please Input a Correct Date, vbInformation
    Exit Sub
    End If
    
End Sub
 
Rajan.
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Jaysheel Bhasme
Sent: Apr/Wed/2012 11:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO 
DATES
 
Hi,
 
Please find the attached sheet.
 
Jaysheel.
On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Please attached file
 
Rajan.
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of karunanithi ramaswamy
Sent: Apr/Wed/2012 11:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES
 
sir,
  I have list of staff with dates of retirement. I want to extract the staff 
who retire between 5/1/2012 and 5/31/2012.
I want the vba code to do this.
thank u in advance.
Karunanithi R
-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com


 
-- 
Jaysheel Bhasme.
-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
-- 
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 Problem, and Need Advice will not get 
quick attention

Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

[karunanithi ramaswamy]

Sir,
This works fine.Thank u very much.
Karunanithi R



 From: Jaysheel Bhasme jaysheel...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Wednesday, April 11, 2012 11:55 PM
Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO 
DATES
 

Hi,

Please find the attached sheet.

Jaysheel.


On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote:

Please attached file
 
Rajan.
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of karunanithi ramaswamy
Sent: Apr/Wed/2012 11:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES
 
sir,
  I have list of staff with dates of retirement. I want to extract the staff 
who retire between 5/1/2012 and 5/31/2012.
I want the vba code to do this.
thank u in advance.
Karunanithi R
-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com



-- 
Jaysheel Bhasme.

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

[karunanithi ramaswamy]

sir,
  I have list of staff with dates of retirement. I want to extract the staff 
who retire between 5/1/2012 and 5/31/2012.
I want the vba code to do this.
thank u in advance.
Karunanithi R

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

[karunanithi ramaswamy]

Sir,
 the file is attached.
 


 From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Tuesday, March 27, 2012 11:39 PM
Subject: Re: $$Excel-Macros$$ REG:$$Column to table formula not working
  

Show us your before/after data and/or send a file with explanation. 

Don 
Guillett
Microsoft MVP Excel
SalesAid 
Software
dguille...@gmail.com 

From: karunanithi ramaswamy  
Sent: Tuesday, March 27, 2012 12:34 PM 
To: excel-macros@googlegroups.com  
Subject: $$Excel-Macros$$ REG:$$Column to table formula not 
working 
 Sir, 
About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has 
given a formula to convert a column to table. 
i.e., =Row(A1)*3-(3-Column(A1))  this works fine when A1 to A100 is 1 
to 100. But not with 10 digit cell phone number 
data.  Can any one suggest any formula or vba.(i am using windows 
2007) 
Karunanithi R-- 
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 Problem, and 
Need Advice will not get quick attention or may not be answered.
 
2) 
Don't post a question in the thread of another member.
 
3) Don't 
post questions regarding breaking or bypassing any security 
measure.
 
4) Acknowledge the responses you receive, good or 
bad.
 
5) Cross-promotion of, or links to, forums competitive to this 
forum in signatures are prohibited. 
 
NOTE : Don't ever post 
personal or confidential data in a workbook. Forum owners and members are not 
responsible for any 
loss.
 
--
To 
post to this group, send email to 
excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


col-table.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

[karunanithi ramaswamy]

Sir,
It is happy to see the desired result. But after typing the formula I pressed 
with ctrl+shift+enter,I dont get the result.
Is there any other procedure? Please help in detail.
Thank you very much.
-Karunanithi R
91-9486100934.
 


 From: Sourabh Salgotra rhtdmja...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Wednesday, March 28, 2012 5:31 PM
Subject: Re: $$Excel-Macros$$ REG:$$Column to table formula not working
  

chk this one.



-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ REG:$$Column to table formula now working

[karunanithi ramaswamy]

Sir,(All forum members)
Re: $$Excel-Macros$$ REG:$$Column to table formula Now working
It is fine.Working well.Thank you very much for your timely help and guidence.
Karunanithi R
 


 From: Sourabh Salgotra rhtdmja...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Wednesday, March 28, 2012 5:31 PM
Subject: Re: $$Excel-Macros$$ REG:$$Column to table formula not working
  

chk this one.



-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ REG:$$Column to table formula not working

[karunanithi ramaswamy]

Sir,
About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has given a 
formula to convert a column to table.
i.e., =Row(A1)*3-(3-Column(A1))  this works fine when A1 to A100 is 1 to 100. 
But not with 10 digit cell phone number
data.  Can any one suggest any formula or vba.(i am using windows 2007)
Karunanithi R

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ USAGE OF RIGHT REPLACE FUNCTIONS IN VBA-REG

[karunanithi ramaswamy]

Hi,
    I am using some vba to filter some  data related with station code, such as 
AVN,CBAVN,CBEAVN,CBTAVN
all the four meas the same station, but used in different software. Here, my 
job is I have to collect the data in
any one of the formate say CBAVN  in any column and then replace them to CBTAVN 
 and proceed.
    I use macro and compile my data(file attached).There are 300 station codes 
.What I want is:
  1.Can i use 'Replace' function in vba code to convert 'CBAVN' IN B1 to 
'CBTAVN' in A1 column.
  2.Can i use 'Right'function in vba code direectly,but it shows 'Object error'

    Thank you if any one helps
  Karunanithi R

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


dewise.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ USAGE OF RIGHT REPLACE FUNCTIONS IN VBA-REG

[karunanithi ramaswamy]

Dear NOORAIN ANSARI,
   THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE.
   Karunanithi R



From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 2:43 PM
Subject: Re: $$Excel-Macros$$ USAGE OF RIGHT  REPLACE FUNCTIONS IN VBA-REG


Dear karunanithi,
 
Please try below VBA Function..and see attached sheet..
 
Function use_cbt(s As Range)
use_cbt = Application.WorksheetFunction.Substitute(s, CB, CBT)
End Function



On Thu, Aug 18, 2011 at 2:30 PM, karunanithi ramaswamy era_...@yahoo.com 
wrote:

Hi,
    I am using some vba to filter some  data related with station code, such 
as AVN,CBAVN,CBEAVN,CBTAVN
all the four meas the same station, but used in different software. Here, my 
job is I have to collect the data in
any one of the formate say CBAVN  in any column and then replace them to 
CBTAVN  and proceed.
    I use macro and compile my data(file attached).There are 300 station codes 
.What I want is:
  1.Can i use 'Replace' function in vba code to convert 'CBAVN' IN B1 to 
'CBTAVN' in A1 column.
  2.Can i use 'Right'function in vba code direectly,but it shows 'Object error'


    Thank you if any one helps
  Karunanithi R-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



-- 

Thanks  regards,
Noorain Ansari
http://noorain-ansari.blogspot.com/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ USAGE OF RIGHT REPLACE FUNCTIONS IN VBA-REG

[karunanithi ramaswamy]

Dear Rajan ,
    thank you very much for your guidelines.  It works fine.
Karunanithi R.



From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 3:33 PM
Subject: RE: $$Excel-Macros$$ USAGE OF RIGHT   REPLACE FUNCTIONS IN VBA-REG


 
Yes you can Use this function in VBA like this 
WorksheetFunction.Replace(parameters)
Right(parameters)
 
 
 
From:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of karunanithi
ramaswamy
Sent: Thursday, August 18, 2011 2:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ USAGE OF RIGHT 
REPLACE FUNCTIONS IN VBA-REG
 
Hi,
 
  I am using some vba to filter some  data related with station code,
such as AVN,CBAVN,CBEAVN,CBTAVN
all the
four meas the same station, but used in different software. Here, my job is I
have to collect the data in
any one
of the formate say CBAVN  in any column and then replace them to CBTAVN
 and proceed.
 
  I use macro and compile my data(file attached).There are 300 station
codes .What I want is:
 
1.Can i use 'Replace' function in vba code to convert 'CBAVN' IN B1 to 'CBTAVN'
in A1 column.
 
2.Can i use 'Right'function in vba code direectly,but it shows 'Object error'
 
 
  Thank you if any one helps
 
Karunanithi R
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

[karunanithi ramaswamy]

Mr Santhosh,
  your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
 i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
AM I RIGHT?
R.KARUNANITHI

--- On Sat, 7/9/11, santosh bahuguna santoshbahug...@gmail.com wrote:

From: santosh bahuguna santoshbahug...@gmail.com
Subject: Re: $$Excel-Macros$$ Numbering
To: excel-macros@googlegroups.com
Date: Saturday, July 9, 2011, 3:59 AM

Use Simple formula 

=COUNTIF(A$1:A1,A1)


Please let me know if you looking for this only 


Regards
Santosh Bahuguna 



On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma rajanverma1...@gmail.com wrote:














Hi

Try this

 

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo Err:

If Target = Range(A1) Then

For i = 1 To Range(A1).Value

Range(A  i + 1).Value = i

Next

End If

Err:

End Sub

 



From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI

Sent: Friday, July 08, 2011 5:38 PM

To: excel-macros@googlegroups.com

Cc: Kal xcel

Subject: Re: $$Excel-Macros$$ Numbering



 



kalyan babu.





Please try it..also





 





=IF(A2=,,COUNTA($A$2:A2))





On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel kalx...@gmail.com wrote:



Dear Experts,





 





I want the formula for below mention query...





 





user will put 100 in A1, from A2 autometically
numbering will start like this





 





A2    1





A3    2





A4    3





.





.





.





.





 





till 100





 





What will be the formula??





 





Please help





 





Thanks in advance





 





Kalyan Chatterjee





 



-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel









-- 



Thanks
 regards,





Noorain
Ansari





http://noorain-ansari.blogspot.com/



 

-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel









-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel






-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ marco to find common value

[karunanithi ramaswamy]

Hi,

Please try this macro. This macro will give reference of numbers that matches 
in D column
i have inserted two columns in bwtween) with col A and also true and also a 
ref of A column
next to D column. Confirm actualy what u want.(i have added 4or 6 numbers for 
examble)
--R.Karunanithi

Sub Compare()
  Dim i As Integer
  Dim j As Integer
  For i = 2 To 36
 For j = 2 To 40
    If cells(i, 1).Value = cells(j, 4).Value Then
   cells(i, 2).Value = True
   cells(i, 3).Value = Row  j
   cells(j, 5).Value = Row  i
    End If
 Next j
  Next i
  
End Sub


--- On Wed, 7/6/11, HARI NAIR hari.shrin...@gmail.com wrote:

From: HARI NAIR hari.shrin...@gmail.com
Subject: $$Excel-Macros$$ marco to find common value
To: excel-macros@googlegroups.com
Date: Wednesday, July 6, 2011, 10:49 AM

I want a marco to find common values of column A and B in column C in the 
attached file. Please Help.




-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


rk-xyz2harinair.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ solution to put data automtically

[karunanithi ramaswamy]

Hi,
 here is a macro u can apply which works well.
Sub test32()
Dim LastRow As Long
Dim j As Long

LastRow = Cells(Rows.Count, A).End(xlUp).row
k = LastRow
For j = k - 1 To 4 Step -1
    If Worksheets(Sheet1).Cells(k, 1).Value = 
Worksheets(Sheet1).Cells(j, 1).Value Then
   Worksheets(Sheet1).Cells(k, 3).Value = 
Worksheets(Sheet1).Cells(j, 5).Value
   Worksheets(Sheet1).Cells(k, 4).Value = 
Worksheets(Sheet1).Cells(j, 6).Value
   Exit For
   
   
    End If
 Next j
  
End Sub

.r.karunanithi.

--- On Tue, 6/21/11, Subhash Yadav scy2...@gmail.com wrote:

From: Subhash Yadav scy2...@gmail.com
Subject: Re: $$Excel-Macros$$ solution to put data automtically
To: excel-macros@googlegroups.com
Date: Tuesday, June 21, 2011, 8:35 AM

Thanks a lot my friend


 
On Wed, Jun 8, 2011 at 10:01 PM, ashish koul koul.ash...@gmail.com wrote:

issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)

reading  =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) 





On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav scy2...@gmail.com wrote:


Dear friends,
 
I am having one sheet containing data for fuel issue.
 
I want, if i put any asset code previous issue and previous reading should come 
from the latest present issue and present reading of same asset.

 
In the attached sheet yellow cell date should come in yellow cell and magenta 
cell data should come in magenta cell.
 
Please help me out.
 

-- 
Subhash Chand Yadav

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


To post to this group, send email to excel-macros@googlegroups.com
 


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



-- 


Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


To post to this group, send email to excel-macros@googlegroups.com
 


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



-- 

Subhash Chand Yadav




-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


SAMPLE FILE-rk.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ help regarding date formula

[karunanithi ramaswamy]

Hi,
   u use this
    =DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not 
blank.
u will get what u want.
  R.Karunanithi.


--- On Thu, 7/7/11, L.K. Modi ca.mod...@gmail.com wrote:

From: L.K. Modi ca.mod...@gmail.com
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011, 10:25 AM

Dear Members,
 
Me attaching a sheet which relates to Excise duty payment.The result should be 
5 of the  next of the month of Invoice.We are currently doing it manually. But 
is there any formula by which we can do that fast and in less time. Hope you 
wil surely help me.

 
Regards
LKModi
 



-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help regarding date formula

[karunanithi ramaswamy]

hi,
the betterr is
  =DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi



--- On Thu, 7/7/11, ashish koul koul.ash...@gmail.com wrote:

From: ashish koul koul.ash...@gmail.com
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011, 11:26 AM


use this    =DATE(YEAR(C4),MONTH(C4),5)


On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi ca.mod...@gmail.com wrote:

Dear Members,
 
Me attaching a sheet which relates to Excise duty payment.The result should be 
5 of the  next of the month of Invoice.We are currently doing it manually. But 
is there any formula by which we can do that fast and in less time. Hope you 
wil surely help me.


 
Regards
LKModi
 



-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel




-- 
Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 





-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help for Excel query

[karunanithi ramaswamy]

HI,
    APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.
   =MAX(A2:C2)
  DOUBTS IF ANY CONTACT.
-R.KARUNANITHI

--- On Wed, 7/6/11, satish narbhaviwithsatishku...@gmail.com wrote:

From: satish narbhaviwithsatishku...@gmail.com
Subject: $$Excel-Macros$$ Help for Excel query
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Date: Wednesday, July 6, 2011, 2:31 AM

Hi,

I want to compare Colum A , B anc C

for ex.


A   B    MOQ
2    1     1       - Select - A
1   2      10     - Select - MOQ
2    4      1      -  Select - B

Basically I want to pick most best selling column for the three taps.

If some can help me out.

Regards

SATISH

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[karunanithi ramaswamy]

Sir,
  Do u have any idea of auto filling magic squre for a particular sum total.  
Iam interested
to know it. Thanks if u could help.
   -R.Karunanithi

--- On Sat, 7/2/11, Rajan_Verma rajanverma1...@gmail.com wrote:

From: Rajan_Verma rajanverma1...@gmail.com
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googlegroups.com
Date: Saturday, July 2, 2011, 8:25 PM




 
 






 



See if it helps 

   



From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anshul Gupta

Sent: Saturday, July 02, 2011 7:39 PM

To: excel-macros@googlegroups.com

Subject: $$Excel-Macros$$ Urgent Help required!! 



   

Hi All.

 

As m working in a import house for that i have to sales bills on daily basis i
just want a help that makes me easy to make that

 

If someone tell that how to make 5 random numbers selection between 197.001 to
203.999 which gives the total of 1000.000

 

Please help meurgent guys 

 

Cheers  

-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel 



 





-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

To post to this group, send email to excel-macros@googlegroups.com

 



Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ $$EXCEL-MACROS$$HOW TO AUTOFILL FOR A GIVEN SUM IN MAGIC SQUARE

[karunanithi ramaswamy]

HI,
  I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
  THANKS IN ADVANCE
-R.KARUNANITHI,2/7/2011.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel