Thanks for the help! Longtime Quatro user here, being forced to use Excel. MS makes great software- too bad they are so obtuse when it comes to the very simplest things. Help is useless... Do they ever do actual user testing? Thank God for YouTube.
Its Great .., But In a workbook i have say 100 sheets
So i maintained a Index sheet ( which has table , which has two columns , one for sheet name , second for hyperlink) . Now In same index sheet i maintain a drop down list to select sheet name & formulated one cell to get corresponding second column of table ).
It worked , on selcting a sheet name , it returned 2 nd column value which is a link name .
you need to show the code man......this is of no use at all.
bdemba16 2 weeks ago
Thanks for the help! Longtime Quatro user here, being forced to use Excel. MS makes great software- too bad they are so obtuse when it comes to the very simplest things. Help is useless... Do they ever do actual user testing? Thank God for YouTube.
dmhsd 1 month ago
that was of great help. thanks.
davidtouthang 2 months ago
Its Great .., But In a workbook i have say 100 sheets
So i maintained a Index sheet ( which has table , which has two columns , one for sheet name , second for hyperlink) . Now In same index sheet i maintain a drop down list to select sheet name & formulated one cell to get corresponding second column of table ).
It worked , on selcting a sheet name , it returned 2 nd column value which is a link name .
But how do i refer a corresponding actual link...
Please help me anybody
Sherlock69Holmes 2 months ago
Great thanks and I love the button idea :)
Amber2856 4 months ago
Itsss greatt thank you alottttttttttttttttttttttttttt
Asha469 5 months ago
Thanks It was very helpful for me
tayyab1234598 7 months ago
it also can be done by using Button, right?
MrSeniorba 8 months ago
Excel for Mac 2011 doesnt give you the option to link within the worksheet!!! It just says 'Website' 'Document' 'Email address'
HELP!
MarkyBoy1234 1 year ago
Thank you so so so much love you you you this the Training that i need so so much tinx love youuuuuuuuuuuuuuu
sameemwafa 1 year ago
Thank you this was great! Which program are you using to record the tutorial? The presentation is great!
reevesdr 1 year ago
Thanks so much! this helped me!!
susyyass 1 year ago
thanxx
drnayyar 2 years ago