|
Excel How to go from list to worksheet?
|
|
Source：Internet Author：Unknow Pubdate：2008-10-28
|
|
sprintcar (Mechanical)
24 Jun 08 16:05
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. It's only a complete day when you Learn something and Teach something!
IRstuff (Aerospace)
24 Jun 08 16:25
The list is gone, but you can still use ^g to get the Goto function and use sheetNN!a1 or somesuch to get to that cell on that sheet.
Might help to post in the spreadsheets forum next time, tho... TTFN
FAQ731-376: Eng-Tips.com Forum Policies
字串4
sprintcar (Mechanical)
24 Jun 08 16:30
Thanks IR
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!
IRstuff (Aerospace)
24 Jun 08 16:43
Oh, OK, what you can do is to define a cell on each sheet with the sheet name, then the Goto list will show all the sheet names and you click the one you want and away you go. TTFN
FAQ731-376: Eng-Tips.com Forum Policies
（Click：）
|
| Previous：Why use C# instead of VB.NET? Next：PIC/ Hobby electronics forums |
|
[ Add TO Favorites]
[TOP] [PRINT]
[CLOCE WINDOWS] |
|
|
|
