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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarize formula links between worksheets
http://j-walk.com/ss/pup/pup5/index.htm
Marilyn wrote: The tool that you mention sounds like it will do EXACTLY what I need. Where can I get it? "Ray Lee" wrote: 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 -- Dave Peterson |
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 |