from vertical, in horizontal , automatically

Originally Posted by manos77

YES. I Want file back with code in. Thanks.

Hi,
. File I here do attached have done you for is ( SpoonFeedADonkeyWanks.xlsm )

. Note: I do must haved to date Format changed is. It may Greek Wolly will not work . You check change if experiment say that do to work then is will ( Must maybe is . enit? )

. Please do say if work good for you is ( or not ! )

..

Using Excel 2007

Row\Col	B	C	D	E	F	G
5	Inicial Date	Final Date	Days	Obs	Type	Name
6	01.01.2015	10.01.2015	10		Half Day Holiday	James
7	01.01.2015	06.01.2015			Wanking	George

DB

Using Excel 2007

Row\Col	H	I	AU	AV	AW	AX	AY	AZ
2			01.01.2015	01.01.2015	01.01.2015	02.01.2015	02.01.2015	02.01.2015
3	NAMES		condition	CAUSE OF ABSENCE	effect	condition	CAUSE OF ABSENCE	effect
4	James			Half Day Holiday			Half Day Holiday
5	Robert
6	John
7	William
8	Richard
9	George			Wanking			Wanking
10	Charles
11	Thomas
12	Michael

DATA PLAN

( George is Wanking again ! )
...................................
Alan