Excel Notation for Documentation?
 

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

Excel Notation for Documentation?
 

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

-----Original Message-----
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
.

Excel Notation for Documentation?
 

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

"K Dales" wrote:

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

-----Original Message-----
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
.

Excel Notation for Documentation?
 

"Pookie" wrote in message
...
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




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---