Sorry if this was asked/aswered already

I need to do the following trick
The data from one worksheet is displayed (and modifiable!) in another
one

Just an example

Sheet1 has RefNO and description in a row

Sheet2 uses its own data plus the description from the Sheet1, locating
the needed row by the RefNO field, and displaying that description

Certainly, I can copy that description to the Sheet2, but in case if it
will be modified on that sheet - on the next update the changes will be
lost ('cause winn be fetched from the Sheet1 again)

Instead, I need this changed description to be automatically updated in
the Sheet1

What is the simplest way to do that?

Thanks a lot


--
moruga
------------------------------------------------------------------------
moruga's Profile: http://www.excelforum.com/member.php...o&userid=29418
View this thread: http://www.excelforum.com/showthread...hreadid=491297