I used a vertical calendar template (columns = months, rows = dates) to create a one-page 2024 Medical & Wellness Appointments.
Is there a way to take that data and convert/move/copy it into a page-per-month layout?
If so,
1. How?
2. Will I need a new workbook, or can there be additional worksheets in the original workbook?
Thanks,
Nancy
There are many ways of doing it, but it would make sense to have the monthly view(s) as extra sheet(s) in your existing workbook.
You could have one sheet for each month, so you would have 12 extra sheets in your file. Alternatively, you could just have one extra sheet and on that sheet you could have a drop-down to allow you to select the month and the display would change automatically.
Which approach would you prefer?
Pete
The first option, please.
Try the attached. It could cover both options. Just copy Sheet 2 and change the month in cell A1. Or you could make A1 have a drop down to select the month. Or both
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I'm not sure how this is any different from what I already have.
Perhaps I wasn't as clear as I could have been about what I'd like to have happen.
What I'm looking for are 12 worksheets, 1 for each month, formatted like a wall calendar, with 7 columns (Sun-Sat) and 4-5 rows, depending on the number of days in the month, and populated by the data on the vertical calendar, Worksheet 1.
Is that clearer?
Did you try copying the sheet that TMS set up for you, as instructed? You would need to duplicate it 11 times.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
@Ali: the OP means four pairs of rows with 7 days each, and a fifth pair with the remaining days (29 to 31). I know how I’d approach it, just not had time to do it. I'd need to set it up on my laptop because I’d want to set up a drop down for the month and Conditional Formatting for the fifth pair.
That said, my approach would be a simple one starting with day one on row 1, day 8 on row 2, etc. it won't move. I'm not up for a varied start. There are lots of Templates for calendars.
Last edited by TMS; 03-09-2024 at 04:05 AM.
This might be closer to what you want.
There are two named cells in the formulae:
Day numbers: =LET(d,DATE(YearToDisplay,MONTH(DATEVALUE(MonthToDisplay&" 1")),1),IF(WEEKDAY(d,1)>=WEEKDAY(B3,1),SEQUENCE(1,7,d-IF(d=B3,0,CHOOSE(WEEKDAY(B3,1),6,5,4,3,2,1,0))),SEQUENCE(1,7,d-IF(d=B3,0,CHOOSE(WEEKDAY(B3,1),6,5,4,3,2,1,0))-1)))
Diary entries: =LET(e,FILTER(FILTER(Calendar2[[ January]:[December]],Calendar2[[#Headers],[ January]:[December]]=MonthToDisplay),Calendar2[Date]=B4),IFERROR(IF(e=0,"",e),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks