Automatically update lists

  • Thread starter Thread starter Whnke
  • Start date Start date
W

Whnke

I have a database of e-mail addresses that I use for target advertisin
for our company.

I have one large database with everyone in there, then I have about 1
peripheral lists that are targeted even more.

I'm trying to figure out how I can just change 1 name and have them al
change in their respective lists. (without having to reference each on
individually)

Thanks!!

-Bil
 
I have it set up right now that the lists are color coded on the secon
sheet and I have the title of each column as a different list. Now wha
I did was put an X in the corresponding column of each e-mail addres
(There are multiple e-mail addresses on the sheet, each one has on
column with an X in it)

Then on sheet 1 I put the master list (non-repeating) and created th
function =if(countif([block of addresses of a specific list], [e-mai
address],"X","")

Basically has the same columns but it puts the X's in the same ro
(instead of having multiples of the same e-mail address with X's i
different columns)

I hope I haven't confused you.

-Bil
 
Back
Top