Linking data using 1-10 pages

[edmar42]

A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with employee name with billable hrs. 2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?

 

[Sheeloo]

If Sheet1 (your master) has name (Col A) and hours (Col B) with multiple rows
for one name and Sheet2 has names in Col A with a header row ...
Enter this in Sheet2 B2
=SUMPRODUCT(--(Sheet1!A1:A100=Sheet1!A1),(Sheet1!B1:B100))
and copy down.
Change 100 to the last row in your dataset.

 

[Bernard Liengme]

The sheet called "Master" has this staring in A1
fred 1
george 2
alice 3
fred 5
alice 2


The sheet called "Sheet2" looks like this:
fred 6
george 2
alice 5


It has the names in column A and in column B the formula:
=SUMIF(Master!A1:A5,Sheet2!A1,Master!B1:B5)
This also works
=SUMIF(Master!A1:A5,A1,Master!B1:B5)

Another way (the best in many cases) is to use a Pivot Table. See anyone of
these
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/
best wishes

 

[muddan madhu]

is this what you are looking for ??

In sheet 1
Col A Names, Col B hours

sheet 2
Col A names , in B2 put this formula =SUMIF(Sheet1!A2:B15,Sheet2!
A2,Sheet1!B2:B15)

the format the col B as [hh]:mm