Excel How to go from list to worksheet?
Excel How to go from list to worksheet?
(OP)
I seem to recall a 'go to' function in either Excel or VB that let's you select a name from a list on worksheet "list" and have the program open that selected sheet, all in the same workbook of course.
I can't find it in my Excel Help section - I guess MS is getting cheaper with the assistance.
I've created a workbook of customers, cell A1 is the account name in all sheets.
Thanks in advance.
I can't find it in my Excel Help section - I guess MS is getting cheaper with the assistance.
I've created a workbook of customers, cell A1 is the account name in all sheets.
Thanks in advance.
It's only a complete day when you Learn something and Teach something!





RE: Excel How to go from list to worksheet?
Might help to post in the spreadsheets forum next time, tho...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel How to go from list to worksheet?
The spreadsheets are just text listing of company name, contact info... nothing fancy
I was hoping to imbed something so it would just be a mouse click on the list name... I can move across all the tabs to the right sheet but that lacks style!
It's only a complete day when you Learn something and Teach something!
RE: Excel How to go from list to worksheet?
TTFN
FAQ731-376: Eng-Tips.com Forum Policies