Hello Paul,

Thank you for taking the time to reply.

I have done more research and found that I probably can't get the
result I want. I want to send a result into the blank cells from cells
containing a formula but Excel is unable to do this.

As I already know the answers to Choices 3 and 4, I might just use
conditional formatting to grey out these cells to indicate no response
is required for these selections.

Again, my thanks for your assistance.


--
Potoroo


------------------------------------------------------------------------
Potoroo's Profile: http://www.excelforum.com/member.php...o&userid=29958
View this thread: http://www.excelforum.com/showthread...hreadid=559227