Ron@Buy wrote:
OK - I was really responding to both your posts.
Anyhow in answer to your last post try this:
[quoted text clipped - 20 lines]
6 should be displayed in the other sheet...Please, is this possible....Thanks
again? or would the original formula you gave me work? Cheers for any help!!!!

The answer to your last question is 'yes' but I need to know the cell
references for each cell (relevant to one driver) where you will enter the R.
I would anticipate the formula looking something like:
=COUNTIF(Sheet1!D20:D26,"=R") This however relies on the R s being entered
in consecutive cells in column D. So the formula may/will change if your
layout is different to this.
I will be away from my computer now till May 18/19. But will come back to
you then if you supply cell references.

OK...the workbook to where I am inputting the letter R is actually named 09th
MAY 2009
, within this workbook there are seperate worksheets named Mon, Tues, Wed,
etc... The workbook that the numbers should be appearing is named, Master 7
day working record, and the different worksheets within that workbook are
named Seven Day 1, Seven Day 2 etc....The only big problem is when inputting
the R against a specific drivers name, is making sure that the number changes
against the drivers name in the Master 7 day working record workbook. The
layout of this Master 7 day working record worbook, is such that name of each
column are Wk End 2-May, Wk End 9-May etc.....So you can see It is quite hard
to sort out aaaaHHHH!!!! Once the letter R is inputted the numbers need to
be appearing under the correct week ending column!!! Sorry for being a pain
to everyone.. Thanks Ron@Buy and Glenn for responding to this project I have
got my self into....Any further help is very much appreciated!!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1