VBA Macro for Data Movement/Deletion

Hello all,

So essentially I need a VBA Macro code for Excel 2003 that can take raw data that is input every month via a text document and move it to the next sheet in the workbook. This data is essentially broken down by a "platform" in the raw data section ("P") with monthly totals for each month but it is broken down by platform in total which goes in descending monthly order on the "dat" tabs (which is the final place for the data).

So what needs to happen is the data for the last two years must go from the "P" tab to the "PDat" tab under the correct platform and the correct spot for the newest month. The data that is input each month is in the same format month to month, just starting two rows down from the last month.

At the end of two years, the oldest year of data must be deleted and the other data moved up to the vacant area so that the sheet never grows too large (ie at the end of this year 2012 will be deleted and all the data will need to get moved up).

Attached is a sample data workbook. Please let me know if this is possible. Thanks and appreciate the help.

Yes, I have looked into recording it. I was more just wondering if there was a short code that could be written instead of going through the process of recording it manually. That would be a very labor intensive process as you must go through each row for each month and copy and paste them. 432 copy pastes.

If there is no other option, and that is the only route, then it will definitely be done.

Okay well here's what I have so far for the deletion aspect of it (assuming that the rest of the 2014 year was filled out). This would be the deletion of data from 2012 and the movement of 2013/2014 up to fit correctly.

Please Login or Register  to view this content.

I get an error in the paste of the range. The range selected to paste the range cut will not populate and I get a run time error 438, "Object doesn't support this property or method".