Macro to Compare two sheet with both sheets h
Solved/Closed
kk
-
Mar 2, 2010 at 02:40 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 2, 2010 at 03:55 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 2, 2010 at 03:55 AM
Related:
- Macro to Compare two sheet with both sheets h
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Compare two excel sheets and highlight differences macro ✓ - Excel Forum
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
- Little alchemy cheat sheet - Guide
- How to screenshot excel sheet - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 2, 2010 at 03:55 AM
Mar 2, 2010 at 03:55 AM
you do not need a macro
in sheet 2 in A2 copy paste this formula
and hit enter key.
I am assuming that there are less than 100 rows. see 100 in the above formula and also see the dollar signs in the formula
copy A2 in sheet 2 down as long as data is there and to the right till the column C
in sheet 2 in A2 copy paste this formula
=INDEX(Sheet1!A$2:A$100,MATCH(Sheet2!$D2,Sheet1!$D$2:$D$100,0),0)
and hit enter key.
I am assuming that there are less than 100 rows. see 100 in the above formula and also see the dollar signs in the formula
copy A2 in sheet 2 down as long as data is there and to the right till the column C