Aug 1, 2004 #1 duncs Structural Aug 17, 2002 10 0 0 JP Hi All, I have excel files whith lots of worksheets, To organise them Id like a tree diagram. Does anyone know of an add-in/or how to do this, so far ive been making VB coded buttons but its still a bit cumbersome. Cheers Duncan
Hi All, I have excel files whith lots of worksheets, To organise them Id like a tree diagram. Does anyone know of an add-in/or how to do this, so far ive been making VB coded buttons but its still a bit cumbersome. Cheers Duncan
Aug 2, 2004 #2 palusa Petroleum Apr 10, 2003 31 0 0 IT Hi Duncan, i came across this as a very nice example of tree-list: http://andypope.info/vba/hlist.htm Hope it could help. _LF Upvote 0 Downvote
Hi Duncan, i came across this as a very nice example of tree-list: http://andypope.info/vba/hlist.htm Hope it could help. _LF
Aug 2, 2004 #3 M MintJulep Mechanical Jun 12, 2003 9,810 1 38 JP How about just cells with hyperlinks? Upvote 0 Downvote
Aug 2, 2004 #4 IRstuff Aerospace Jun 3, 2002 44,376 5 38 US If you couple the hyperlinks with the outlining function in Excel, you'll essentially have a tree diagram TTFN Upvote 0 Downvote
If you couple the hyperlinks with the outlining function in Excel, you'll essentially have a tree diagram TTFN
Aug 17, 2004 #5 joerd Chemical Sep 27, 2002 531 0 0 US And if you download ASAP utilities for free from http://www.asap-utilities.com then you can have it create the index page automatically for you (amongs loads of other useful things) Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips. Upvote 0 Downvote
And if you download ASAP utilities for free from http://www.asap-utilities.com then you can have it create the index page automatically for you (amongs loads of other useful things) Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.