Wanting to transfer associated data from one sheet to another, with rows dependant on a cell value

[HAREA93]

EXAMPLE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1
2			MONDAY					TUESDAY
3			4/11/16					4/12/16
4			NUMBER REQUIRED	Start	Finish	Item	Total	NUMBER REQUIRED	Start	Finish	Item	Total
5	POSITION	TYPE		Time	Time	Hours	Hours		Time	Time	Hours	Hours
6
7	POSITION A	X	1	12:00	13:00	1.00	1.00	2	12:00	13:00	1.00	2.00
8	POSITION B	X	3	12:00	15:00	3.00	9.00	1	12:00	15:00	3.00	3.00
9	POSITION A	Y	2	13:00	16:00	3.00	6.00	1	13:00	16:00	3.00	3.00
10	POSITION C	Y	1	14:00	19:00	5.00	5.00	3	14:00	19:00	5.00	15.00
11	POSITION D	X	1	11:00	14:00	3.00	3.00	1	11:00	14:00	3.00	3.00
12	POSITION D	Z	2	12:00	14:00	2.00	4.00
13	POSITION E	X	1	12:30	16:00	3.50	3.50	2	12:30	16:00	3.50	7.00
14
15	TOTAL NUMBER		11					10
week 1

Cell Formulas
Range	Formula
H3	H3	=C3+1
F7:F13,K7:K13	F7	=IF(E7<D7,HOUR(E7)-HOUR(D7)+24,HOUR(E7)-HOUR(D7))+(MINUTE(E7)-MINUTE(D7))/60
G7:G13,L7:L13	G7	=SUM(C7*F7)
C15,H15	C15	=SUBTOTAL(9,C7:C13)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H7:H13	Cell Value	>=1	text	YES
C7:C13	Cell Value	>=1	text	YES

Cells with Data Validation
Cell	Allow	Criteria
F7:F13	Any value
K7:K13	Any value

EXAMPLE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1
2
3		DATE	MANUAL INPUT	ORDER	MANUAL INPUT	POSITION	TYPE	START	FINISH	MANUAL INPUT	MANUAL INPUT			DATE	MANUAL INPUT	ORDER	MANUAL INPUT	POSITION	TYPE	START	FINISH	MANUAL INPUT	MANUAL INPUT
4				1										4/11/16		1		POSITION A	X	12:00	13:00
5				2										4/11/16		2		POSITION B	X	12:00	15:00
6				3										4/11/16		3		POSITION B	X	12:00	15:00
7				4										4/11/16		4		POSITION B	X	12:00	15:00
8				5										4/11/16		5		POSITION A	Y	13:00	16:00
9				6										4/11/16		6		POSITION A	Y	13:00	16:00
10				7										4/11/16		7		POSITION C	Y	14:00	19:00
11				8										4/11/16		8		POSITION D	X	11:00	14:00
12				9										4/11/16		9		POSITION D	Z	12:00	14:00
13				10										4/11/16		10		POSITION D	Z	12:00	14:00
14				11										4/11/16		11		POSITION E	X	12:30	16:00
15				12										4/12/16		12		POSITION A	X	12:00	13:00
16				13										4/12/16		13		POSITION A	X	12:00	13:00
17				14										4/12/16		14		POSITION B	X	12:00	15:00
18				15										4/12/16		15		POSITION A	Y	13:00	16:00
19				16										4/12/16		16		POSITION C	Y	14:00	19:00
20				17										4/12/16		17		POSITION C	Y	14:00	19:00
21				18										4/12/16		18		POSITION C	Y	14:00	19:00
22				19										4/12/16		19		POSITION D	X	11:00	14:00
23				20										4/12/16		20		POSITION E	X	12:30	16:00
24				21										4/12/16		21		POSITION E	X	12:30	16:00
25
26
27						THIS IS WHAT I AM TRYING TO FORUMLATE									THIS IS WHAT SHOULD OUTPUT
28
29						DATE, POSITION, TYPE, START, AND FINSH; DRAWN FROM SHEET 1
30
31						AMOUNT OF ROWS PER POSITION IS DEPENDANT UPON 'NUMBER REQUIRED' COLUMN ON SHEET 1
32
Sheet1

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Not sure if can be formula or if code required? Help please!!
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.