I FOUND SOMETHING....WWWWOOOOOHHHHOOOOWWWW.... John Walkenbach's ... PUP v6
Addin ...

Does what I was looking for, and sooo much more....


--
Thanks for all of the help. It is much appreciated!!!!


"BSc Chem Eng Rick" wrote:

I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Bean Counter" wrote:

Hi Gurus!!

I have a workbook that contains about 20 worksheets. Some of these
worksheets are operations files from other departments, but others are a
consolidation of the data. Not only are there hundreds of links to other
workbooks, but there are hundreds of links between worksheets within the same
workbook. Is there any way I can trace all of these links (aside from doing
it manually)? This document is carrying a lot of extra baggage, and that is
making it extremely difficult for me to understand what is going on.

As I was searching for the answer to this question, I stumbled upon a tool
posted by Bill Manville titled "find links". This is a super cool tool, and
one I am definitely keeping, but it does not give the option on searching
within the same workbook for links. Here is a quick link for those
interested in this handy, dandy tool..

http://www.oaltd.co.uk/MVP/Default.htm

--
Thanks for all of the help. It is much appreciated!!!!