We have several mailing lists, that do not share the same people. What I would like to accomplish is have a master spreadsheet where once we enter a persons name/info it updates automatically on which ever mailing list they are on. The only solution I know to implement would be the IMPORTRANGE function. However if I were to add or remove cells this would cause more trouble than it;s worth and we have over 400 contacts. Any way to attach a formula to a name(Ie Edward Smith) then have the rest of the row copy info from the master sheet? Sorry I am novice at this

In that case, what is the point of having sub-sheets if all the data will be on a master sheet? Surely a column on the master sheet could be used to indicate which mailing list each person is on, then filter by that column for mailing purposes.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

That is deceptively easy...... Is their a way to print off the data I've used as a csv? The main point is to use the address list for the mail merge function.

Ah this function exists within mail merge

There is no need for the csv - you can use Word's mailmerge, which includes the necessary filtering tools, directly with the Excel data source.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]