I have a list of cells that contain client #'s in one sheet and another sheet
that has a bunch of data which I need to filter for each client #. (After it
is filtered, I'm copying that data into a new sheet, that part I have figured
out) What code can I use to look at a range of cells, and for every non-blank
cell, switch to the data sheet and select the filter, and then repeat for
every non blank cell one time?

Thanks
Vick