VBA Macro for Continuously Copying Data

October 28, 2010 at 11:20:51
Specs: Windows XP
I am new to Excel Macros (2003) and need help automating the function below:

I have a Workbook with 3 sheets of data sorted by years 2009, 2010, and 2011. I need a Macro to copy ALL data in columns A thru C in EACH 2009, 2010 and 2011 into a NEW sheet for EACH Year. Then, as additional data is stored in sheets 2009, 2010, and 2011... I would like for it to automatically be copied to the new sheets each time.

Please help!

See More: VBA Macro for Continuously Copying Data

Report •

October 28, 2010 at 17:01:54
You should post this problem here:


Report •
Related Solutions

Ask Question