compare and merge worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top