I have two worksheets in one Excel (2003) workbook/file. One is a source
worksheet into which all data flows. The other is static, displaying the data
into a different format for non-Excel users to look at the data more easily.
This second, destination worksheet gets its data from the source worksheet.
For example, cell A2 in the destination worksheet has the equation:
=SOURCE!F22. But when I re-sort the data in the source worksheet, the
equation in cell A2 in the destination sheet stays the same (i.e.
=SOURCE!F22), rather than picking up on the fact that the data in F22 has
moved to another location and reading it (e.g. it has moved to E33, so A2 in
the destination sheet should now read =SOURCE!E33). How can I get the
destination worksheet to change and read the same data in its new location
with each re-sort of the data in the source worksheet? Thank you so very
much.