how do i filter multiple tables of data whilst keeping headers in tact?

Hi hunterdraygon
You show that you're using excel 2003 but you attach an .xlsx file. You must be using 2007 up ?? Update profile please
I think I worked out what you want to do. Try the attached file. On sheet 2 there's a button at the top. It's your file renamed with code.
cheers
Phil

Please Login or Register  to view this content.

Thank you philb, this looks fantastic.

I'm actually using 2010, could this be a reason for the bug in it?

It works a charm, thank you very much.

i know beggers cannot be choosers, however, it always opens up on a new spreadsheet and overwrites the original one. is there maybe any way that it can write onto sheet2? that way i can just edit sheet1 then press the button. also, would it be too much to reove the product/quantity headers row? please.

Again. Thank you

We're almost there then. It copied to sheet2 & then deleted sheet1 & sheet3. I've changed it so it doesn't delete any sheets, starts pasting from row 5 on sheet2 to allow for a decent sized button & it doesn't copy the product description rows now
Good luck
Phil

Please Login or Register  to view this content.