Excel Notation for Documentation?

[Guest]

Hi,
We need to create some documentation for mappings between two spreadsheets.

What notation / methods have people used / are people aware of that will
enable us to do this?

Basically we have some input spreadsheets which are consolidated into some
different output sheets. We need to map where the output data comes from in
the input sheet(s).

Many thanks in advance.
Andy

 

[K Dales]

For situations like this I usually use comments inserted
into the cells of interest specifying where the data comes
from/goes to.

 

[Guest]

Thanks for the reply,
I was really looking for something outside of the physical excel sheets.
Regards,
Andy

 

[Keith Willshaw]

Hi,
We need to create some documentation for mappings between two spreadsheets.

What notation / methods have people used / are people aware of that will
enable us to do this?

Basically we have some input spreadsheets which are consolidated into some
different output sheets. We need to map where the output data comes from in
the input sheet(s).

Many thanks in advance.
Andy

There are several options

1) Use a series of hidden worksheets. We have some
workbooks were each spreadsheet has a hidden mapping
sheet containing the metadata abut where the cell value
comes from.

2) Embed or attach a link file with the same data

3) Use an associated XML file

Keith