Build a schedule or order form from a pricing sheet

[hermunn123]

I created a pricing spreadsheet that builds the model number of a product as you select the size and options. Spreadsheet is below:

Excel Workbook
	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
1	E7 Narrow - 480V
2	Rated Input Voltage	Nominal HP (1)	Rated Output Current (Amps)	Tag		Model Number		NEMA 1 Bypass				Main Input Disconnect						Drive Input Circuit				Impedance				Uses Drive Model Number CIMR-E7U
3												0 = Disc. SwitchC = MCP Circuit BreakerD = Fused Disconnect						G = Disconnect SwitchB = 3 Contactor Bypass				X=3% Bus ReactorZ=5% Bus Reactor
4								E7NV	Base Net $	Quantity	Total	C	Add (Y/N)	Total	D	Add (Y/N)	Total	G	B	Add (Y/N)	Total	X	Z	Add (Y/N)	Total
5												Net $			Net $			Net $	Net $			Net $	Net $
6	480V	1/2	1.6			E7NVB001GXY		B001	100	5	$ 500.00	50			100			STD	50			STD	50			a
7		3/4	1.6					B001	150		$ -	50			100			STD	50			STD	50			b
8		1	2.1					B002	200		$ -	50			100			STD	50			STD	50			c
9		2	3.4					B003	250		$ -	50			100			STD	50			STD	50			d
10		3	4.8					B004	300		$ -	50			100			STD	50			STD	50			e
11		5	7.6					B007	350		$ -	50			100			STD	50			STD	50			b
12		7.5	11					B011	400		$ -	50			100			STD	50			STD	50			c
13		10	14			E7NVB014CGZY		B014	450	3	$ 1,350.00	50	y	$ 150.00	100			STD	50			STD	50	y	$ 150.00	d
14		15	21					B021	500		$ -	50			100			STD	50			STD	50			e
15		20	27					B027	550		$ -	50			100			STD	50			STD	50			b
16		25	34					B034	600		$ -	50			100			STD	50			STD	50			c
17		30	40					B040	650		$ -	50			100			STD	50			STD	50			d
18		40	52					B052	700		$ -	50			100			STD	50			STD	3% Bus Reactor is standard			e
19		50	65					B065	750		$ -	50			100			STD	50			STD				b
E7N 480V - Narrow

I will have several different tabs (upwards of 15-20) that will have pricing for different models. I would like to be able to generate an order form and schedule on separate tabs. The order form would be something like this:

Excel Workbook
	C	D	E	F	G
7	Order Form
8	Tag	Quantity	Model Number	Individual Price	Total Price
9	D-1	5	E7NVB001GXY	1234.56	6172.8
10	D-2	3	E7NVB014GZCY	2345.67	7037.01
Sheet1

And the schedule would be something like this:

Excel Workbook
	I	J	K
7	Schedule
8	Tag	Quantity	Model Number
9	D-1	5	E7NVB001GXY
10	D-2	3	E7NVB014GZCY
Sheet1

Niether one is very extensive but I'm not sure how to go about getting this started. The fact that this single tab could be pulling from one or several different tabs has me confuzled... among many other things.

I don't know how to write macros but I'm thinking this might be a good time to learn how to. (Where's a good place to research macros and how to build them?)

Thanks for any help...

 

[hermunn123]

Do I need to clarify my problem better?