Excel Notation for Documentation?

P

Pookie

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

K Dales

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

Andy

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

Keith Willshaw

Pookie said:
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
Click to expand...

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
 
Top