You're welcome. Thanks for the rep.
Point of note for future reference: it's always best to ask the question you want answering, not a hypothetical question with a sample workbook that doesn't reflect the live environment.
To be selective about the sheets, use
To filter on column F, use:
The code:
just determines the last row of data. It's equivalent to selecting the last/bottom row on the spreadsheet and pressing End followed by Up-arrow and looking at the row of the cell selected. In this instance it is based on column B as that is the column that is populated with a formula.
The revised code would look like this:
Regards, TMS
Bookmarks