User avatar
sayhello
Posts: 89
Joined: Sat Mar 05, 2016 1:02 pm

rework a template - in order to create a weekly calendar

Tue Jul 24, 2018 1:35 pm

hello dear community,

well this might be some kind of slightly off topic here - but i want to ask a certain question - since i need some help here...
weekly_vertical_demo.jpg
weekly_vertical_demo.jpg (12.82 KiB) Viewed 1058 times
the task i have a excel sheet with 365 lines of information.
the task: i need to rework this - in order to create a weekly calendar - in portrait formate
aim: i need to create a little booklet - out of the content that is contained int the calc-sheet

question: is there a option to go from calc to a calendar template(in vertical - portrait formate) on the direct way ?

see the attached files .

Code: Select all


01.08.18 	1 	8 	2018 	Bla 1 	Blub 1 	Blabla 1 	
	
02.08.18 	2 	8 	2018 	Bla 2 	Blub 2 	Blabla 2 	
	
03.08.18 	3 	8 	2018 	Bla 3 	Blub 3 	Blabla 3 	
	
04.08.18 	4 	8 	2018 	Bla 4 	Blub 4 	usw. usf 	
	
05.08.18 	5 	8 	2018 	Bla 5 	Blub 5 	usw. usf 	
	
06.08.18 	6 	8 	2018 	Bla 6 	Blub 6 	usw. usf 	
	
07.08.18 	7 	8 	2018 	Bla 7 	usw. usf 	usw. usf 	
	
08.08.18 	8 	8 	2018 	Bla 8 	usw. usf 	usw. usf 	
	
09.08.18 	9 	8 	2018 	Bla 9 	usw. usf 	usw. usf 	
	

love to hear from you

scotty101
Posts: 3750
Joined: Fri Jun 08, 2012 6:03 pm

Re: rework a template - in order to create a weekly calendar

Tue Jul 24, 2018 1:55 pm

Copy and Paste with the Transpose option to rotate the data.
Electronic and Computer Engineer
Pi Interests: Home Automation, IOT, Python and Tkinter

Return to “Off topic discussion”