Making a linked reference

[yellowredblue]

Hi

I have question about linked reference in excel. I have block of cells in terms of days of different months.

I have made it dynamic therefore, the days change with changing the month and year.

I would like to link each date of the cell with new worksheet. Therefore, when I click for instance

first of day November 2011, it automatically opens a sheet with name of Nov-01-2011 and has the text Nov-01-2011 written in the sheet.

Thank you for your help

Kind Regards to all

 

[My Aswer Is This]

Welcome to the Forum yellowredblue
Please explain this more.
"first of day November 2011, it automatically opens a sheet with name of Nov-01-2011 and has the text Nov-01-2011 written in the sheet."
Are you saying you want to open the sheet named "Nov-01-2011" or are you saying you want to create the sheet Named "Nov-01-2011"
And when you say "and has the text Nov-01-2011 written in the sheet."
Where do you want it written in the sheet or do you mean name the sheet.
Normally with sheets we don't open them we either activate them create them or Hide or show them. We open "Workbooks"
If you can clear this up I will see if I can help you.