Sheet 1: Master list that has column headings of various employee info (names, ID, address,etc). There are 100 employees in this list.
Sheet 2: Same column headings as Sheet 1, but the columns are not filled out with any employee info.
I need a formula so that when I'm in sheet 2 and I type in a last name, it auto fills from the master list of employee info on sheet 1. So in sheet 2, I have first and last names filled out for 10 employees out of the master list of 100 employees, but I need it to populate the data to include ID, address, etc).
Can anyone help me with this please?
To clarify, I'm entering weekly hours for payroll. For my report, I need all of these column headings existing in the Master sheet 1. However, I only have the first and last names and their hours in front of me and I need it to populate the data form sheet 1 into sheet 2 when I type in the names. Note, only 10-15 employees work each week and it always varies.
Bookmarks