Can i use a date picker to go to worksheets that are named as dates
I have a workbook that has 365 worksheets, one for everyday of the year. They are named by date. Can I use a date picker to go to the corresponding worksheet. I am using Excel 2013
»
- Karleen73's blog
- Login or register to post comments
- 4417 reads
Hyperlinking to Worksheet
If you have a main worksheet that acts as your dashboard, I would just add a dynamic link to that worksheet that takes you to the day's worksheet. For example, in the below formula, "Book4.xlsx" is the name of the workbook (hardcoded, but you could dynamically build it using the CELL("filename") function. Also, I am imagining that the date format is in YYYYMMDD format, but you can adjust it accordingly. I have the formula set to go to "TODAY()"'s date, but you could change that to any other reference and make the hyperlink work.
=HYPERLINK("[Book4.xlsx]'"&TEXT(TODAY(), "YYYYMMDD")&"'!A1", TEXT(TODAY(), "YYYYMMDD"))
RE
Hello
Add a macro to go to the sheet of today, if this is what you want. If you want something else please be more specific. (I mean like double click in calendar, or so)
Sub forEachWs()
Dim ws As Worksheet
DateOfToday = Format$(Date, "dd-mm-yyyy")
For Each ws In ActiveWorkbook.Worksheets
If ws.Name = DateOfToday Then
ws.Activate
End If
Next
End Sub
edit: did change Subject
I would like to be able to
I would like to be able to double click in a calendar to go to the specific worksheet. The worksheets are named ddmmyy. I need to change between dates often. Many Thanks