Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Look up VBA documentation using Excel Help | Excel Programming | |||
Documentation 4 Excel Web Component | Excel Programming | |||
Excel Format documentation | Excel Programming | |||
Excel Object Documentation | Excel Programming |