Macro to copy a Workbook, only keeping specific data

[RichJW]

Hi,

I have an (O365) Excel report, with two tabs, which is my master version.
I need a macro that will do the following for me, as I need to produce several reports from this master version.

1. Copy the master version.
2. Only keep the rows of data where in column D it says "Apples" in both tabs (header is on row 4 on each tab, so data commences on row 5 and the number of rows with data changes weekly). So, for anything saying "Pears" or anything else in column D, the row gets deleted.
3. Name the file "Apples Report", so basically whatever filter I am looking at.

I can then just duplicate this macro for my other categories.
I need to do this for about 5 reports, so it would help me greatly.

Thanks,
Rich

 

[RichJW]

@mumps Wow, thanks so much, that works beautifully. Sorry for the delay, been to a Christmas event. Merry Christmas

 

[mumps]

You are very welcome and same to you.