Filter, Copy, Paste Dynamic ranges

Hi,

I am really annoyed with myself as I know I have done this in the past.

I have a Workbook with about 30 Worksheets with the last one being an overview of the previous 29. ("Summary")
I have the same table on each of the first 29 ws from columns A to O. Row 1 is the headings and the total number of rows varies sheet to sheet.
In Column M the cells can only be A, B or C.

How do I write the vba code that upon selecting the "Overview" ws, the following happens;

• Everything but the headings is deleted
• Each list on the previous ws's are filtered to only show A's & B's in Column M
• Each filtered list is copied (without headings) to the Overview ws
• Each pasted data is appended to the bottom of what is there already

I appreciate any help you could give me.

Please find sample attached.

There are no macros in this at the moment.
It shows that each list was filtered to not show anything ranked as a 'C' and then copied across into 'Overview'

Any questions, please ask.

Am I asking for too much?
It would also work to copy the entire data from each worksheet (without the headings) to the Overview worksheet and then filter the list there to remove all C rankings.

You are very kind. My brain just can't seem to work it out today...or yesterday...

Try

Please Login or Register  to view this content.

You...are...awesome!!
Many thanks

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.