Hi,
I have 30000 cells of data occupying Row B. This data is updated quarterly and 100 cells of data occupying Row A. Updated Weekly.
Currently we autofilter by row A (100 times - Imagine.) and delete all instances of filtered data found in Column B by filtering.
There must be a better way. Any suggestions please.
I have 30000 cells of data occupying Row B. This data is updated quarterly and 100 cells of data occupying Row A. Updated Weekly.
Currently we autofilter by row A (100 times - Imagine.) and delete all instances of filtered data found in Column B by filtering.
There must be a better way. Any suggestions please.