Combining worksheets
 

I have a mailing list on 3 separate PCs, which are not networked. Can I
update the lists separately, then combine them onto a Master? Of
course, I don't want to lose data, and need to keep from having
duplicate and triplicate entries.

Is this possible?

Thank you very much to anyone who can assist me!


--
walshpark
------------------------------------------------------------------------
walshpark's Profile: http://www.excelforum.com/member.php...o&userid=26761
View this thread: http://www.excelforum.com/showthread...hreadid=400135

walshpark Wrote:
I have a mailing list on 3 separate PCs, which are not networked. Can I
update the lists separately, then combine them onto a Master? Of
course, I don't want to lose data, and need to keep from having
duplicate and triplicate entries.

Is this possible?

Thank you very much to anyone who can assist me!

Try using Advanced Filter with "Unique records only" checked on the
combined file
Ilan


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=400135