|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.