| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto hyperlink between many sheets?
I have a book with about 80 sheets(accounts), and I need to do 2 things: 1. hyperlink to each sheet by the sheet name. the name is also in hte actual sheet 2. have a master sheet with info from each of the 80 sheets. this will be about 3-4 entries for each account. the info is from a form, and all of the needed entries are on the same cells for each sheet. can I use some sort of formula to auto-populate this info? if I can get the data from all 80 accounts on one sheet, I can manually hyperlink them pretty easily. thoughts? -- gab2409 ------------------------------------------------------------------------ gab2409's Profile: http://www.excelforum.com/member.php...o&userid=20483 View this thread: http://www.excelforum.com/showthread...hreadid=549091 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
| Auto filling cells across mutliple sheets | Excel Discussion (Misc queries) | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Question about auto fills or linking sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
