Really Need Help pulling data from 3 tables on 1 sheet into other sheets, but not all

i am a supervisor and have to pull data from 3 sources that all export to excel, so i copy and past to create 3 tables on sheet 1.

I then need to take some of the data from each table and fill out a form for each ee.

Is there a way, that i can get the form to auto fill from the data on sheet 1. I have 21 employees, so data from 21 rows of each of the 3 tables needs to auto fill the form on each employee page.

I have attached a sample of what the data looks like and where it needs to go in the form.

Thanks for any assistance. It will be a huge time saver.

The main sheet is "data", EE1 is the employee 1 form, etc....

Hi,

It's probably easiest if you use a vLookup. Please see attached.

Dave

that looks like it will work but what does it mean so i can edit if i ever need to?

=VLOOKUP($C$7,Data!$A$3:$W$12,16,FALSE)

Firstly, the dollarsigns just stop the reference from changing when you copy the formula.

the vLookup basically searches the leftmost column of a specified range and returns the value in the column you want so - $C$7 is the value to find (in your case employee), "Data!$A$3:$W$12" is the range where the data is located ie sheet is called "Data" and the range is all employees and stat1 to 22, the "16" refers to the column containing the value you want to return in this case Stat15. Finally the "FALSE" ensures that you get an exact match and if one doesn't exist the formula result will be FALSE.

To be honest Excel probably explains it better than me, select a cell containing one of the formula and click the "fx" button next to the top input bar.

Thanks for your help