Parse items include repeat section headers

Hi
I am trying to use one Jerry Beaucaire macro to

1. Filter the Master report
2. Copy all to individual sheets

The problem I am having is I have

1. the 1st 7 rows are a title block that needs to be repeated onto each sheet with formulas that index to the data

2. on the bottom rows 410:419 have a signature block that needs to be repeated on each sheet

3. In the data there is 4 header rows labeled in column C as "e, f, m, p" . If when filtered there is no data under one of these then the header row needs to be hidden.

I have attached my workbook for assistance

Thank you very much in advance for the help.

Lee

Hi Jerry

Thanks ever so much for the assistance.

I have included a sheet of what I need and also the sheets of what I am getting

Never to old to learn this but my mind get totaly muddled.

Thanks

Hi

I have managed to write the code and the report comes out perfect. Code is a bit long winded but works.

Only issue is I have to keep changing the Criteria1:=Array("1" the 1 to each filter number.
of which there is to be 43. Is there a way of automating this?

Thanks

Please Login or Register  to view this content.

Hi Jerry

Thanks have tried everything but can't get the M string to work.

It just keep filtering the "a", "e", "f", "m", "p" part only and pasting and ignoring the numbers.

If I change the m to 1 Criteria1:=Array(m,
...... it works perfect except it only brings the one sheet out.

Any other suggestions ?

Thanks
Lee