How to I 'write-through' a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've learnt through (minimal) experience that it helps to have one worksheet
that contains all the raw data (each column per field) and other worksheets
to display views of the raw data for different user groups. In other words
the other views reference the main worksheet cells with formula (e.g.
=rawdata!E9).


Can I create a cell in a view-worksheet so that it writes through directly
to the rawdata spreadsheet?

(I don't want the rawdata worksheet to reference the view because I know
I'll run into sort problems when the views reference each other
bi-directionally).

Suggestions greatly appreciated,
Tom
 
a worksheet_change event in the sheet module to look for the next available
row in the destination sheet and copy the target value to that cell.
 
Hi Don,
Thanks for the fast answer. Before I dive in to the documentation to learn
about eventing could you just let me know if this involves VB (beyond me)?
All the best,
Tom
 
Back
Top