Comparing 2 columns and adding missing values

January 12, 2011 at 12:24:51
Specs: Excel
Is it possible to have set range of values in one sheet compare to another in a different sheet and if the range we compare to has new values copy and paste to the original sheet?


See More: Comparing 2 columns and adding missing values

Report •

#1
January 12, 2011 at 13:34:51
What not just set the first sheet "equal to" the second sheet?

=SHEET2!A1
=SHEET2!A2
=SHEET2!A3
etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 12, 2011 at 13:51:16
That will work! Thanks!!!!

Report •
Related Solutions


Ask Question