There is one summary sheet titled
"All Closed".
There are fourdata sheets titled.
-"Non Event-Closed"
-"Earnings-Closed"
-"Positive Comments-Closed"
-"Syndicate-Closed"
Each data sheet has rows of data starting in row 12. I need help writing a macro that can copy every row with data on the five data sheets and combine them on the summary sheet ("All Closed"). Once all of the data is copied to the summary sheet then sort the data by date ascending (Column B).
Thanks
Last edited by rhudgins; 03-17-2011 at 08:48 AM.
Try this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This works but the workbook that this code will be used in has more worksheets in it. How can the code be changed to copy from only those four data sheets?
Change this one line:
Please Login or Register to view this content.
Thank you for your solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks