Vlookup between sheets

[motz_the_lr3]

hello,


I need to create this report but I need your help


I uploaded sample file here :
https://app.box.com/s/p9uv3mbhwoop2wobrfky3v3fvwj6ci27


So I have main chart in Sheet1 and I will be inputting weekly data in each tab.


Weekly data includes different kinds of datas.


But I need
-Only certain employees. Sheet1 has a list of employee numbers. I need a format that searches the employees numbers in Sheet1 and their data.
-I only need certain data.


So for example, in the sample file,
I need to pull


-Data 4,7,10,13,18 and 27


on


Employee numbers 48511, 49324, 43610, 49612, 36473, 43434 and 49446.

I need a format that generates the data automatically when I copy and paste the weekly data in each tab.


I greatly appreciate your help.

[FDibbins]

I uploaded sample file here :
https://app.box.com/s/p9uv3mbhwoop2wobrfky3v3fvwj6ci27

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites.

I have not looked at your file, but vlookup works the same withing a single sheet, across 2 sheets and even between different files.

If this still doesnt help, I will wait for you to upload your sample workbook here

[motz_the_lr3]

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites.

I have not looked at your file, but vlookup works the same withing a single sheet, across 2 sheets and even between different files.

If this still doesnt help, I will wait for you to upload your sample workbook here

Ok i feel stupid but i didn't know how to attach a file on this thread lol!!!

I attached a file on a new thread and I appreciate if you check the sample file for me.

New Thread with a file : http://www.excelforum.com/excel-form...ml#post4243551

Thank you very much!