Not sure if can be formula or if code required? Help please!!

[HAREA93]

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
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
Sheet2

EXAMPLE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
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
16
Sheet1

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

 

[Fluff]

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

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.