Creating a Macro that Copies Data While Moving Down Spreadsheet

[kcratskcor]

I posted this last night but didn't attach the workbook so I thought I would try again, I hope that's okay


I'm very new to VBA and am having trouble figuring out how to build this. I have been able to get a macro to work for just one line of the table but haven't been able to make it cascade down the table. An example for row 2 of the table is this

-Take Cells A9-E9 and copy them to A2-E2

-Run 3 macros that are saved in the workbook. These macros sort tables that I have on sheets 2-4 based on the data A1-M2 (applyGreater, applyLesser, applyPush).

-Copy Cells G6-K6 and paste them as values to G9-K9 (G6-K6 are aggregate functions that update based on the data in the Sheet2-4 Tables.

-Move down to row 3 of the table and repeat the process using data in that row. I need it to keep doing this until the table ends (Row 3609).

I hope I was clear with my instructions. Thank you for any and all help!

[davesexcel]

I think you want to loop through column A and copy A:E to A2

Please Login or Register  to view this content.