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