merge sheets

[Mark Kurten]

is there a way to take data from one worksheet and merge it into another
worksheet (which already contains similar data) and to have it not merge the
duplicate data?

 

[Dave Peterson]

Does merge just mean copy the second worksheet's data at the bottom of the first
worksheet's data?

If yes, you could do that and then use some of the techniques at Chip Pearson's
site to eliminate the duplicated rows (if you have a key column in your data).

http://www.cpearson.com/excel/duplicat.htm

I guess it depends on what your definition of merge is.