Hi, I'm trying to hyperlink cells with specific data to external excel files, but have no idea how to do it (rather than do it one by one for 363 cells). Basically, the spreadsheet has data sorted by person's name and the month relevant to them, and I have external spreadsheets for each month of this year. What I want to do, is hyperlink the month name in the first spreadsheet to the external spreadsheet for that same month. Does this make sense??? I can do this one by one but since there is data for 363 people, it would take forever! So I was wondering if there was a macro that could do it automatically? Any help would be very much appreciated!

Thanks,
Sharn