Re: Easy One ....I think....

Thanks Earl......wow...Im totally stuck now tho.............

Dave :)

Anymore ideas anyone ???



"Earl Kiosterud" <someone@xxxxxxxxxxx> wrote in message
news:exZsR1pDHHA.3600@xxxxxxxxxxxxxxxxxxxxxxx
Dave,

Doable, but not particularly easy, as you have the data in 6 separate
workbooks. Consider making one table (one ***) with all this data.
Check out "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. Yours is across
multiple workbooks, but the principle is the same.

Also, you've combined the start and stop times. You'll want to separate
them. You can do that with formulas in two new columns, then trash the
old stuff. Entering them will be easier, and your time calculations will
be way more straightforward.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"DB" <db002a3121@xxxxxxxxxxxxxxxx> wrote in message
news:eF59h.5378$k74.2556@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I use excel to prepare duties at work.........basically i have 6
workbooks......monday thru to saturday....I have everyones start and
finish times, aswell as a breakdown of tea break...meal breaks etc......

Is there a way I can take the values of a particular cell.....say B 10
from each page....this cell will always contain the start and finish
times.....i.e.......a text entry stating....08.50 - 17.35...

Is it possible to list someones basic hours on a page 7 of a
workbook..all it would have to do is repeat the text entry that is in B10
for one person........C 10 for another etc etc....

It sounds simple but I cant quite get there.

Any help would be appreciated.....



Many Thanks

Dave :)








.