kittu akula
New Member
i am looking for a vlookup VBA code for my project.
i have Multiple sheets llike sheet1,sheet2,sheet3,....upto sheet7 in these sheets i have different columns and a usernames column (column B) as common. i have one more sheet8 in same excel work book in that i have only one column with name usernames (with usernames at column A )
now i want to vlookup sheet1 to sheet7 with sheet8 and what ever names are matching should be there in report and which are not maching with usernames in sheet8 should be deleted in all sheets from sheet1 to sheet7( i.e NA should be deleted)
Please let me know if its possible with VBA code
i have Multiple sheets llike sheet1,sheet2,sheet3,....upto sheet7 in these sheets i have different columns and a usernames column (column B) as common. i have one more sheet8 in same excel work book in that i have only one column with name usernames (with usernames at column A )
now i want to vlookup sheet1 to sheet7 with sheet8 and what ever names are matching should be there in report and which are not maching with usernames in sheet8 should be deleted in all sheets from sheet1 to sheet7( i.e NA should be deleted)
Please let me know if its possible with VBA code