getting data across spreadsheets

[debbz82]

Hi ~ I was wondering how do I access data from a different sheet but th
same workbook. I'm doing a spreadsheet about payroll, and I wanted t
transfer part of that data onto sheet2. I think I use the dge
function but I'm not quite sure how to use it. For example, I woul
want to access the number of hours a employee worked from sheet1 an
put it in sheet2. Thanks!!!!

Debbi

 

[Cesar Zapata]

Debb,

You may wanna try Vlookup. check in the help for more info.


Lets say you have in Sheet 2 employee and hours in cell a1 to b10

then in sheet1 B1 type =Vlookup(A1,sheet2!$A$1:$B$10,2,false) ' is looking
in sheet2 based on a1 value use false to find exact match.

now in A1 type the name of the employee.


to make things easier you can use data validation so you dont have to type
the names in Sheet1

to do this go to sheet 2 and select A1:B10 and name it EmpList

then go back to sheet1 and select a1 then click on Data> Validation> at the
pulldown select List and in the box type.

=EmpList.




Hope it helped you.

Cesar Zapata

 

[Jim]

=SUMIF(Employees="Joe Blow",Hours) where you have ranges named Employees and
Hours. If yu want to narrow it down, say for a week or two weeks, post back.