Depleting list

  • Thread starter Thread starter Robo7084
  • Start date Start date
R

Robo7084

I have a list of names that I require information from. I
need to follow up only the people who have not returned
their figures.
I am after a way of removing the name from the list as I
receive the information from them.
A simple example would be to have the master list on
worksheet 1 (W1). In column A, I have their names, in
column B I put the figure I receive from them.
In worksheet 2 (W2) I would have the same list of names in
column A but over an "if" formula.
As I receive the figure and enter it in column B of W1,
the "if" formula in column A in W2 would recognise an
entry and the name would disappear.
I can then copy the list from W2 into a mailout and only
be hassling the lazy people.
Like I said this is a simple example but if you can start
me off I can go from there.
Thanks
Stephen
 
The data>advanced filter function will allow you to filter the list and
copy the result to the next sheet.
You will need to have a column on the original sheet that identifies
the ones you want to filter for/exclude.
 
Back
Top