hyper link control

Hi

I have attached a sample sheet
The index sheet has hyper links attached the the various sheets which works fine, my question is as more sheets are added this
index list will grow and will have to be scrolled to to locate newer date entries...can the list be controlled to list the number of viewable lines then start a new column
Or even better can a calender set up be created to point to the links????


Thanks Peter

You have not attached a sample sheet

[Hi sorry about that it should be attached now

One question : you now have multiple sheets per day, by adding the (2) and (3) - in the end, will there be 1 sheet per day or still possible to have for example "Wed12th June 2013 (2)" and "Wed12th June 2013 (3)"

Hi Jasper

sorry i just copied a few sheets over and it generated the () numbers, they would be one sheet monday and one sheet wednsday every week (at the moment) and named that day/date/year
The end number can be left in if that makes things easier?

Peter

I am guessing that the sheets are auto-generated. If so, can you name the sheets in the macro that creates them just by "Date"? (Set Sheet.Name = Date)
Then I can use that to extrapolate the day / month from the datevalue of the sheet name and link it to a calendar style overview I made.
Would be easiest

Hi Jasper

No i have just been maually adding the sheets (not sure how to write a macro to do this)?

Peter

Hi Jasper

Do you have a code that could add sheets from a list and copy template date at the same time ???


Peter

Easy answer : yes
Complicated answer : I'm on the road till next weekend, so don't have time to do it
If by next weekend no one did it for you, I'll fix it ��

Thank you Jasper

Hi

Jasper did you have time to look at this yet ???

Peter