Excel filter with Sub-heading rows

[Liverlee]

Hello all.

Can anyone help me with this issue. I have a spreadsheet that has numerous sub headings merged across random rows in a data set. We'd like to be able to apply a filter (i.e filter the id column and see all returns for either 1, 2, or 3) but still see the various sub heading rows.

Is there a way to do this?

?

 

[JEC]

You should change your setup. Put your headings in rows as well

 

[Liverlee]

You should change your setup. Put your headings in rows as well

That's the problem, it's not my set up - it's my colleagues template and they've asked is it possible to filter it without breaking their template.

 

[JEC]

Break the template. You can't work properly with this setup.
Is there always three cells between the headers? A lot is possible with VBA, but VBA does not like merged cells as well.

 

[Liverlee]

I hate merged cells for this reason.

Yeah i was wondering if i could do a vba but it's a random number of rows which throws another spanner in the works.

I might create a separate sheet for of the i.d's at the moment there's only 4 and run a vlookup or something to extract the info