Copy & Paste Macro

[williadb]

Hi

I admit im a compelte newbie to VBA and need some help.

Im trying to consolidate data in one sheet colelcting data from the other 3. The header row in all 3 sheets is the same. id like it to copy data in sheet 1 with the header row and then goto sheets 2 and copy the data under the data from sheet 1 and repeat going to sheet 3, so that the data on all 3 sheets is consolidated nicely under the 1 heading with no gaps in the data.

Can anyone help me, it would be much appreciated.

 

[texasalynn]

take a look at the consolidate feature of excel, by clicking on the use label in Top row the header won't be repeated