compare and merge worksheets

[Guest]

I have 2 worksheets with some of the same data. How can i do a compare and
then merge the data from the 2nd worksheets into the first one?

 

[Dave Peterson]

Cell by cell comparison?

A1 with A1, Q12 with Q12, AC232 with AC232?

If yes, then you could use a program written by Myrna Larson and Bill Manville.

You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

======
If that's not it (you may have inserted/deleted rows or columns) can you pick
out a nice unique field in each worksheet?

If yes, then maybe you can use =vlookup() or =index(match()) to retrieve the
values from one worksheet and put them into helper columns on the other.

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.