Excel Multi select VBA Coding
Solved/Closed
Related:
- Excel Multi select VBA Coding
- Excel multi-select listbox without vba - Guide
- Moving the data into previous cell by using excel formula or VBA code ✓ - Forum - Excel
- Vba code to search data in excel - Guide
- Vba code to compare two excel sheets and copy differences ✓ - Forum - Excel
- Vba code to compare two excel sheets and highlight differences ✓ - Forum - Excel
1 reply
Excelguru
Jun 10, 2009 at 07:35 AM
- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Status
- Member
- Last seen
- June 21, 2011
Jun 10, 2009 at 07:35 AM
Hi
you can do it without a macro
Put the following formula in cell B1 of sheet 2 (Assumes the name is in column A)
=if(iserror(vlookup(A1,sheet1!A:A,2,false) ),"",vlookup(A1,sheet1!A:A,2,false)) and drag it down
If you want a macro record your above activity
you can do it without a macro
Put the following formula in cell B1 of sheet 2 (Assumes the name is in column A)
=if(iserror(vlookup(A1,sheet1!A:A,2,false) ),"",vlookup(A1,sheet1!A:A,2,false)) and drag it down
If you want a macro record your above activity
Jun 10, 2009 at 10:48 AM
Awesome!!
Dec 11, 2009 at 02:07 AM
=if(iserror(vlookup(A1,sheet1!A:A,2,false) ),"",vlookup(A1,sheet1!A:A,2,false))