Build Table Based on Cell Values

[jski21]

Good day Mr. Excel Team!

Is there a way to build a table based on cell values? Example: I'm tracking journeymen and apprentices. There is a variable ratio depending on the trade. For simplicity here, let's say there has to be 2 apprentices for each journeyman (2:1). So if I entered 2 for journeymen (Cell B1) and 2 for apprentices (Cell B2), the resulting table would have 2 journeyman entries and 4 apprentice entries. Like this:

Sample.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	Y	Z	AA	AB
1	Number of Journeymen:	2
2	Apprentice Ratio:	2
3
4
5
6
7	Week #18		S	M	T	W	Th	F	S	Total	Name	Hrly Rate	Total Fringe	Fringe hrly	Total per hour	Wage Dec. Hr	Wage Dec. Fring	Wage Decision total	Wage Overtime Rate	Jrny Wage Difference	Jrny Overtime Difference	App Difference	App OT Difference	Apprentice Rest S Hrs	Apprentice Rest OT Hrs	App Wkr Rest S	App Wkr Rest OT	Restitution payment
8	Dates		9-Apr	10-Apr	11-Apr	12-Apr	13-Apr	14-Apr	15-Apr
9	Jrny 1 S	Straight	0.00		8.00	8.00	8.00	8.00		32.00	Jrny 1 S	33.74	816.32
10	Jrny 1 OT	OT								0.00
11	Jrny 2 S	Straight	0.00	8.00	8.00	8.00	8.00	8.00		40.00	Jrny 2 S	33.74	1,020.40
12	Jrny 2 OT	OT								0.00
13
14	App 1 S	Straight	0.00	8.00	8.00	8.00	8.00	8.00		40.00	App 1 S	28.68	928.40
15	App 1 OT	OT								0.00
16	App 2 S	Straight	0.00				8.00	8.00		16.00	App 2 S	20.24	20.45
17	App 2 OT	OT								0.00
18	App 3 S	Straight	0.00	8.00	8.00	8.00	8.00	8.00		40.00	App 3 S	20.24	396.72
19	App 3 OT	OT								0.00
20	App 4 S	Straight	0.00	8.00	8.00	8.00	8.00	8.00		40.00	App 4 S	20.24	396.72
21	App 4 OT	OT								0.00
Data

Cell Formulas
Range	Formula
J14:J21,J9:J12	J9	=SUM(C9:I9)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L21	Cell Value	<IF(L21>0,L20*1.5)	text	NO
L19	Cell Value	<IF(L19>0,L18*1.5)	text	NO
L15	Cell Value	<IF(L15>0,L14*1.5)	text	NO
L17	Cell Value	<IF(L17>0,L16*1.5)	text	NO
L12	Cell Value	<$L$6*1.5	text	NO
L10	Cell Value	<IF(L10>0,L9*1.5)	text	NO
L12	Cell Value	<IF(L12>0,L11*1.5)	text	NO

There are 2 rows per entry (straight time and overtime). No worries on the dat shown here as that is entered by a user. I can get the headings filled and other bits through VBA, I just don't have the expertise to get the basic table built based on the cell values.

Many thanks in advance for the review and guidance.


jski