Hidden info in cells

[Russ]

I keep a list of club members on an Excel database and as
members come and go I delete the info in cells and add new
members as appropriate. However when copying a list of the
email addresses for bulk emailing the system picks up old
email addresses which have been deleted as well as the
current address in the cell. Does anyone know why and how
do I stop it?

 

[JE McGimpsey]

If you deleted the information from the cell, it's gone so either:

1) you're not deleting the info (i.e. hiding the rows rather than
deleting them, or

2) The "system" is picking up the info from somewhere other than the
cells. Information can be stored in workbook or worksheet names, in
other sheets, other workbooks, etc. That doesn't seem likely if you're
"copying" the list manually. Are you/the system using some other method?