I am a very basic excel user, sorry for that first off.
I am currently trying to set up a daily planner linked to a monthly calendar. I have figured out how to hyperlink the monthly calendar to the daily planner sheets ie. click on the date on the monthly calender and the corresponding daily plan sheet "pops" up.
a) is there an easier way to do this for each day instead of doing 365 individual hyperlinks
b) I am looking for a formula to add the date to the top (cell K1) of each daily plan sheet. Not sure how to write it so that the date is one day ahead on each successive sheet.
I am using excel 2010
I realize this is basic stuff, but it's something I don't know how to do
Thanks for your help.
I am currently trying to set up a daily planner linked to a monthly calendar. I have figured out how to hyperlink the monthly calendar to the daily planner sheets ie. click on the date on the monthly calender and the corresponding daily plan sheet "pops" up.
a) is there an easier way to do this for each day instead of doing 365 individual hyperlinks
b) I am looking for a formula to add the date to the top (cell K1) of each daily plan sheet. Not sure how to write it so that the date is one day ahead on each successive sheet.
I am using excel 2010
I realize this is basic stuff, but it's something I don't know how to do
Thanks for your help.
