Good morning,
I am looking for a tool that would allow me to diagram which worksheets are connected to which other worksheets. I'm using Excel 2010 with a workbook that is Excel 2000 compatible. For instance sheet 4 draws from Sheet 1 and Sheet 3 to calculate it's contents. Anyone aware of a tool that would help me in doing that?
Thanks,
Bill
Last edited by billfinnjr; 09-17-2018 at 06:25 AM.
the following code
Please Login or Register to view this content.
Tim201110,
Thanks much! With a couple of minor tweaks it worked fine. I do have a couple of questions though
1. In several places there is data that clearly isn't English. I tried translating from Russian to English using Word, no luck. Tried a couple other languages with no luck
2. Is there a easy way to modify this to show each link between two worksheets once? That's sufficient for this part of the project. I'm using a pivot table right now to do this but the result isn't what I am looking for
Again, thanks very much!
Bill
Last edited by billfinnjr; 09-17-2018 at 08:10 AM.
this part is important
Please Login or Register to view this content.not clear what you wantIs there a easy way to modify this to show each link between two worksheets once?
Currently the macro gives me a new worksheet with over 20,000 rows. I'd prefer a list that shows each worksheet, and one row for each of the worksheets it reaches out to for data. As an example assuming two columns;
Sheet 1 Sheet 3
Sheet 1 Sheet 5
Sheet 1 Sheet 9
Sheet 1 Sheet 11
Sheet 2 Sheet 5
Sheet 2 Sheet 6
Sheet 2 Sheet 12
Sheet 3 Sheet 4
Sheet 3 Sheet 7
Sheet 3 Sheet 8
I'm currently paring it down with a pivot table but the result isn't exactly what I'm looking for
Thanks much,
Bill
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks