Excellent peice of work!!!!
need one more help what if it was vice versa, we can take the same example
taking A61 USA and its repeating 3 times till A18, and I want one consolidated
file which will give a summary of unique items which has USA in column A and
the result should be year like 2001, 2002, 2003.
same like vlookup but the result is unique then keep on adding with a comma for
that look up.
Regards,
Shan
--- On Wed, 2/10/10, ayush jain <jainayus...@gmail.com> wrote:
From: ayush jain <jainayus...@gmail.com>
Subject: Re: $$Excel-Macros$$ EXCEL HELP
To: excel-macros@googlegroups.com
Cc: somasekhar2...@gmail.com
Date: Wednesday, February 10, 2010, 8:43 AM
Hi Somasekhar,
Attached is the solution for your reference. Use the below macro to implement
the task. Let me know if any further assistance is required.
Sub distribute()
copystartrow = 16
Beginrow = 4
Endrow = 9
Sheets("Sheet1").Range("A3:D3").Copy
Sheets("Sheet1").Range("A" & copystartrow - 1 & ":" & "A" & copystartrow -
1).PasteSpecial
For i = Beginrow To Endrow
For j = 1 To Sheets("Sheet1").Range("B" & i)
Sheets("Sheet1").Range("A" & i & ":" & "D" & i).Copy
Sheets("Sheet1").Range("A" & copystartrow & ":" & "A" &
copystartrow).PasteSpecial
copystartrow = copystartrow + 1
Next
Next
End Sub
Best regards,
Ayush Jain
Group Owner
On Tue, Feb 9, 2010 at 10:35 PM, somasekhar duvvapu <somasekhar2...@gmail.com>
wrote:
hi,
Can anybody help me for writing excel macro.
plz find the attached excel sheet for the problem,
with regards,
sekhar
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
Best regards,
Ayush Jain
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
