Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarize formula links between worksheets
I love using John Walkenbach's PUP tool, especially the ones related
to auditing. I was wondering if anyone has taken the Formula Report one step further. Currently, the report can lists all formulas on all worksheets. This list can get overwhelming and I would like to see a summary report that just lists each worksheet along with names of other worksheets that are referenced within its formulas as well as a formula count. For example, to show that Sheet1 has 5 formulas referencing Sheet2, I would like to see the following: Sheet1 Sheet2 5 It would be nice to also have a list that shows the other direction where I can see the names of other sheets that reference the active sheet with a count. I summary I am looking for a high-level listing of the formula dependencies among my worksheets within a workbook. Thanks, Ray Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I summarize items chosen on mulitiple worksheets | Excel Worksheet Functions | |||
how do I combine multiple worksheets into one? not summarize | Excel Worksheet Functions | |||
summarize data from multiple worksheets | Excel Discussion (Misc queries) | |||
How do I Find links in worksheets - not in any formula | Excel Worksheet Functions | |||
Bond prices: summarize ranges from different worksheets | Excel Programming |