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