Problems with my Work rota set-up
 

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

Problems with my Work rota set-up
 

DO NOT Answer this one cos im sorted thanks to Pete_UK

Dave :)


"DB" wrote in message
k...
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 :)