Dated Planner Spread

[Mhakiwa]

Hi

I am not new to planner design and layout, however I am a complete newbie at data merge (it can my my life much easier if I know how to use it) 

I've attached a basic planner layout of how I imagine the design to look.  The second shows the reality which is that all the information is the same.  I have tried several different ways of creating a very basic spreadsheet, sadly the result is the same.  All this information needs to be on the same page, please can you point me to a video/tutorial that can help with this.  

Planner dates.xlsx

Edited August 12, 2022 by Mhakiwa

[Old Bruce]

Off the top of my head I think you need to use the Data Merge Tool to create a (sort of) table with four rows and one column (or four rows and two columns) then place the fields for the days in the upper right (sort of) cell.

I am not at all certain what your layout is, is it a week on one page or two pages.

[Mhakiwa]

Hi thank you for this.  This is a week over 2 pages (A4=A5) size just for ease of printing (I sell these undated at present). I will give your suggestion a go. Thanks Bridget

[Old Bruce]

Had a look at the spreadsheet, you'll need to insert every Eighth day of the week, the one named Notes. And you'll need to get January repeated in all the rows.

[David in Яuislip]

Each row in a spreadsheet is a record and each record will display on a new page so it needs to be restructured
I am not good with the Data Merge Layout Tool so if that's the answer I apologise

Disclaimer:
It's very hot here

Planner datesVersion2.xlsx PlannerTest.pdf PlannerTest.afpub