Greetings.
I'm using Excel 2007, in case it matters for the situation.
In dealing with a workbook made up of 42 different worksheets, there are many cross populations occurring in that one piece of cell data will be used in a formula to feed a value and that value used in another worksheet, etc. We've all done that one way or another.
I'm interested in being able to list, document, print, etc. what the source of a value in a cell is.
For example, you have a summary sheet and in A1 is sheet30!A44 and in A2 is sheet32!B96, etc. You can tell that by going to A1 and the source shows in the value line.
I want to be able to print that sheet showing what the source of A1 is, not the resulting value there... and for all the cells on that sheet.
In essence, I want to be able to build a documentation listing of this cross pollination.
Any thoughts about how one would achieve this result?
Thank you for your time and consideration.
LJ
I'm using Excel 2007, in case it matters for the situation.
In dealing with a workbook made up of 42 different worksheets, there are many cross populations occurring in that one piece of cell data will be used in a formula to feed a value and that value used in another worksheet, etc. We've all done that one way or another.
I'm interested in being able to list, document, print, etc. what the source of a value in a cell is.
For example, you have a summary sheet and in A1 is sheet30!A44 and in A2 is sheet32!B96, etc. You can tell that by going to A1 and the source shows in the value line.
I want to be able to print that sheet showing what the source of A1 is, not the resulting value there... and for all the cells on that sheet.
In essence, I want to be able to build a documentation listing of this cross pollination.
Any thoughts about how one would achieve this result?
Thank you for your time and consideration.
LJ