Hi, how can I copy the data from sheet 1 to 2 based on the title in sheet 2?
For example
Sheet 1
Employee ID Name Birth date Gender Grade
123 Peter 1-1-2000 M 1
456 John 1-2-2000 M 2
Sheet 2
Employee ID Birth date Grade
123 1-1-2000 1
456 1-2-2000 2
I am using vlookup in sheet 2 based on Employee ID to lookup the birth date and grade from sheet 1 to sheet 2. But, I feel really time-consuming when I have so many column titles in both sheet 1 and 2. Any shortcut to paste the data directly from sheet 1 to 2 based on the title in sheet 2?