I've got around 53k rows of data in an excel worksheet, labelled Data. Each
row has a customer ID. I've put all the data into a pivot table on another
worksheet, which is how I want to display the results. However, I don't need
data for all customer ID's. In a separate worksheet, I've got a list of
unique customer ID's that I need information on.
Is there any way (perhaps VB code/macro?) that I can look in the datafile of
53k rows, find a customer ID, compare that with the unique list of ID's and
if it's in there then ignore it (not do anything with it), and if it isn't in
there, remove it from the datafile?