Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in excel from a list
Hi all
I have 2 spreadsheets I'm trying to streamline. One has an overview by date and time of trainers and their scheduled courses, ie a basic group calendar. The other has more detail for each instance of each course containing attendees, location, etc, by date. At the moment they're not linked at all so it's a bit unwieldy for the users. I want to be able to populate cells on the summary sheet from a list containing names of training courses, and have the data displayed as a hyperlink, which when clicked would take me to the 2nd spreadsheet with the further details. I'll need to be able to pass in the date and time of the particular instance of the course to navigate to the correct point in the 2nd spreadsheet. Hope that makes sense! I'm happy to have a bash at this in vba, using eg worksheet_change events, but I just wanted a sanity check that there's not an easier way that I've overlooked. I've investigated smart tags but they look V complicated. many thanks for your suggestions Richard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in excel from a list
hi, Richard !
try starting on David McRitchie's site: - Coding a link address and friendly name using HYPERLINK Worksheet function http://www.mvps.org/dmcritchie/excel....htm#hyperlink hth, hector. I have 2 spreadsheets I'm trying to streamline. One has an overview by date and time of trainers and their scheduled courses, ie a basic group calendar. The other has more detail for each instance of each course containing attendees, location, etc, by date. At the moment they're not linked at all so it's a bit unwieldy for the users. I want to be able to populate cells on the summary sheet from a list containing names of training courses, and have the data displayed as a hyperlink, which when clicked would take me to the 2nd spreadsheet with the further details. I'll need to be able to pass in the date and time of the particular instance of the course to navigate to the correct point in the 2nd spreadsheet. Hope that makes sense! I'm happy to have a bash at this in vba, using eg worksheet_change events, but I just wanted a sanity check that there's not an easier way that I've overlooked. I've investigated smart tags but they look V complicated. many thanks for your suggestions Richard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in excel from a list
On 25 Sep, 21:47, "Héctor Miguel"
wrote: hi, Richard ! try starting on David McRitchie's site: - Coding a link address and friendly name using HYPERLINK Worksheet function *http://www.mvps.org/dmcritchie/excel....htm#hyperlink hth, hector. I have 2 spreadsheets I'm trying to streamline. *One has an overview by date and time of trainers and their scheduled courses, ie a basic group calendar. *The other has more detail for each instance of each course containing attendees, location, etc, by date. *At the moment they're not linked at all so it's a bit unwieldy for the users. I want to be able to populate cells on the summary sheet from a list containing names of training courses, and have the data displayed as a hyperlink, which when clicked would take me to the 2nd spreadsheet with the further details. *I'll need to be able to pass in the date and time of the particular instance of the course to navigate to the correct point in the 2nd spreadsheet. Hope that makes sense! *I'm happy to have a bash at this in vba, using eg worksheet_change events, *but I just wanted asanitycheck that there's not an easier way that I've overlooked. *I've investigated smart tags but they look V complicated. many thanks for your suggestions Richard- Hide quoted text - - Show quoted text - Hi thanks for your prompt reply, I'll give it a look! Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
excel drop down list of hyperlinks | Excel Worksheet Functions | |||
hyperlinks from a list? using excel 2000 | Excel Discussion (Misc queries) | |||
Hyperlinks from a List, Excel 2000 | Excel Worksheet Functions | |||
Hyperlinks from a List, Excel 2000 | Excel Worksheet Functions |