Database-like cross-worksheets links

[moruga]

Sorry if this was asked/aswered already

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

Just an example

Sheet1 has RefNO and description in a row

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

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

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

What is the simplest way to do that?

Thanks a lo

 

[Dave Peterson]

I would think that the simplest way to do it is to lock those cells on sheet2
that have the =vlookup() formula that retrieves the description from sheet1 (and
protect sheet2).

And update sheet1 directly with the change.