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
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