"dingbat via OfficeKB.com" wrote:

Ron@Buy wrote:
OK - I was really responding to both your posts.
Anyhow in answer to your last post try this:
In the cell where you want the one to appear enter this formula:
=IF(Sheet1!D20="R",1,"")
Replace Sheet1 with the name of your worksheet where you enter the R (note
the ! needs to be included) Change D20 to the cell reference into which you
enter the R.
Now when you enter R a one should appear.
Hope this helps

Dingbat
I think what you're asking here is far too big a project to be handled
[quoted text clipped - 15 lines]
other sheet in the other workbook...Thank you for you reply.... hope that you
can solve any problems that pop up in the future...Thanks again

Thanks again.... Would it be possible once the letter R is inputted into the
cell to change the number on the worksheet to the number 2 and so forth... so
when say on a monday the employee reports for work, the letter R is inputted
and the number on the sheet changes to a No1, so when the same employee
reports for work on the Tuesday, R is inputted as before, but the No1 in the
other sheet, then changes to the No 2... so when Saturday comes around the No
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!!!!


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


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.