Hi!

Is there a way in which I can define a range of cells in a worksheet in which

1) upon manual data entry
2) safe the data and its position as identified by the cell values of the first two cells in the row
and
3) update the corresponding cell (in the same position) with the same two ID-cells in another worksheet is updated with the newly entered manual data

So it basically works as a VLOOKUP - just the other way round (VWRITEIN? ;-)). Ideally without freezing excel every time somebody writes something in a field (it's ~400 rows and 30 columns).

Background of this question is that I generate a dynamic report based on input data in 2 worksheets. Now the users of this report would propably have a hard time understanding that everything they write into the (dynamic) report disappears once they click on "generate new report".

All help is greatly appreciated! Thank you.

Best regards,
Andreas