Hi again,
Today was the day to get the macro's running and all went well untill I ran the last one and the data did not continue onto the next sheet.
I had not thought about this as I had moved onto excel 2007 but had to go back to 2003 to be compatible with other software for this project.
My problem is:
The final macro to populate the data runs but stops after it gets to the bottom of the sheet at line #65474. This is past where the first two macros populated.
The other two macros stop input at line #65410 on the first two sheets and line #3394 on the third sheet. This is ok.
I need the final macro to populate the data down to line #65410 on the first sheet and then continue with the data from line #3 on the next sheet down again to line #65410 and then to line #3 on the final sheet down to line #3394 on the last sheet.
The workbook is too large to post up so I am trying my best to describe what I want to happen.
To sumarise, the macro needs to populate the data as below to match the data from the first two macros.
data 1 First line #3 Last line #65410
data 2 First line #3 Last line #65410
data 3 First line #3 Last line #3394
Can you help again.
Regards
Bookmarks