Really hoping someone can help me on this one, as I have spent hours
trying to figure out and there must be a simple way to do it.

I have an invoice template, where the sales person enters the product
code into one cell and then the description then appears in the
adjacent cell using the following formula:

=VLOOKUP(C27,'Y:\Excel\[Product
Codes.xls]Sheet1'!$A$2:$B$26597,2,FALSE)

I want the sales person to be able to change the description if
necessary i.e. add the colour of the product etc.

But of course in the description cell is the formula and not the actual
text I have asked it to return.

I know you can do this with paste special then values, but I dont want
the sales people to have to paste special all the time. I want it to do
it automatically.

I have never used VBA and to be honest cant face trying to learn it at
this point. Is there a simple way of doing this?

Many thanks in advance to anyone who is able to help.

April


--
aprillachlan
------------------------------------------------------------------------
aprillachlan's Profile: http://www.excelforum.com/member.php...o&userid=29785
View this thread: http://www.excelforum.com/showthread...hreadid=555010