Populate data over more than one sheet

[Butehawk]

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

Please Login or Register  to view this content.

Can you help again.

Regards

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

[Butehawk]

Hi Jerry,
This sort of worked but only populated sheet 1 and 2.
Then gave an error message of "Run time error" "Copy method of range class failed.

Please Login or Register  to view this content.

Any ideas?

Roger

[snb]

Please Login or Register  to view this content.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up your workbook.

[Butehawk]

Thanks SNB
Your macro hangs up at the (.rows.count,3) stage.

Please Login or Register  to view this content.

[snb]

these sheets should be available :
IBS Data 1
IBS Data 2
IBS Data 3

[Butehawk]

Thanks everyone for their help.
In the end I had to split the data into three separate sets of 700 rows in different workbooks and then run Jerry's macro on each one. Maybe not the best way but it worked and I have all the data I require.
Thanks again

[JBeaucaire]

Next time, try posting the wb so we can see the same problems you do, solutions may come much faster and accurately that way.

Thanks!