Macro to copy and paste changing number of rows

[phil3061]

Hello,

I'm looking for help for a macro that will copy and paste a range of data onto a new sheet. I've attached the workbook, with some sample data. Basically what I need is for each header, ie "Mega AHT", copy the data below it (A3 - F7) then paste it onto a new sheet. Then come back and grab "Inet AHT" (A9 - F14), copy and paste it onto a new sheet.

This is a daily report, so the range of the data changes daily. Any help would be greatly appreciated.

[DGagnon]

Try this Macro out

Please Login or Register  to view this content.

[Dennis7849]

How many blocks are there that need to be setup on their own sheets?

Are the number of rows for each block always the same(like always 7 rows tall)??

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[phil3061]

You guys are awesome. They both worked great. Thanks so much!!