I have an excel 2003 Spreadsheet which is generated automatically by a report each day, it always has the same headings, but different number of rows of data. For the example call it SS1
I have another spreadsheet (SS2) excel 2010 this has 3 tabs, historical, cl, rp.
I want to write a macro that copies the data from SS1, line 2 onwards, then first of all copies it to SS2 - tab historical. Each day the macro will be run, so it will need to determine the end of the data in the historical tab and add it to the next line.
Column C has a column called type (values cl or rp). If the type is cl it will copy all of the data from historical where type is cl to the cl tab and where the type is rl to the rl tab.
Again this will be cumulative each day, so it needs to determin the last line of data in cl and rp and add it to the line after
Is this possible?