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