Need some help in coming up with a Macro. I have two excel spreadsheet. Both have Employee ID and Values in column A and B respectively. Spreadsheet 1 has columns A to G populated but Spreadsheet 2 has only A and B populated. I wanted columns C to G to be populated in spreadsheet 2 if A and B columns matches with the spreadsheet 1. Also, Column A can have same employee ID getting repeated. I got it to work using vlookup but not that great in Macros.
Any help would be greatly appreciated.