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

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 :)






.

Loading