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

Just because you didn't like Earl's answer doesn't mean you should
repost in another group - it wastes a lot of time. Keep to the original
thread. (Check it now for another answer).

Pete

DB wrote:

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

OK pete......but I was thinking more on the lines of the more people I
ask,the more chance of someone helping me.
I didnt say I didnt like his answer....it was getting a little technical and
I couldnt understand it...I'm a bit of a newbie with excel and whilst there
is a lot of help on google etc,some of it assumes you know a lot already.
I stand officially bollocked.....lol

Thanks Dave :))


"Pete_UK" wrote in message
oups.com...
Just because you didn't like Earl's answer doesn't mean you should
repost in another group - it wastes a lot of time. Keep to the original
thread. (Check it now for another answer).

Pete

DB wrote:

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