Insert Multiple Rows & Insert Data per other wksht

[ARich4JC]

I have a good one here. I have a Table of (GetPivotData items). However, to update the Table to include (new) Freeport & Baton Rouge, I must first:

1) Add the new site info (col. A), With the Years to insert (col. C and along with the Quarters (col. F - I: see pattern)
2)Tell it how many additional rows needed (col. E) in the Mstr Table.
3) Insert # of Rows, Copy/Paste Special Values in the Columns A, C & D) of the Mstr_GPD_Table. Has a Pattern of each Consignee per # of Year(s) (listed in Table) w/ 4 Qtrs to each year.

Harder to explain...Easier to show.


My Input Table (Consignee Data Table):

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Consignee Number	Consignee Name	Year Start	Year End	Rows Needed	Quarter1	Quarter2	Quarter3	Quarter4
2	75-2778918CK	Cookeville	2006	2016	44	Q1	Q2	Q3	Q4
3	75-2778918LB	Lynchburg	2006	2016	44	Q1	Q2	Q3	Q4
4	75-2778918LV	Louisville	2006	2016	44	Q1	Q2	Q3	Q4
5	75-2778918PT	Pittsburgh	2006	2016	44	Q1	Q2	Q3	Q4
6	75-2778918RL	Raleigh	2006	2016	44	Q1	Q2	Q3	Q4
7	75-2778918SP	Springville	2006	2016	44	Q1	Q2	Q3	Q4
8	75-2778918SS	Sulphur Springs	2006	2016	44	Q1	Q2	Q3	Q4
9	75-2778918WV	Woodlands	2006	2016	44	Q1	Q2	Q3	Q4
10	75-2779018FV	Freeport	2006	2016	44	Q1	Q2	Q3	Q4
11	75-2778918BR	Baton Rouge	2007	2009	12	Q1	Q2	Q3	Q4
Consignee Macro Data Table

Excel 2007

Cell Formulas
Range	Formula
A2	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A3	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A4	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A5	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A6	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A7	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A8	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A9	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A10	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
A11	=IF(ISBLANK(ConsigneeInfoTable[[#This Row],[Consignee Number]]),"",ConsigneeInfoTable[[#This Row],[Consignee Number]])
B2	=IFERROR(VLOOKUP(A2,ConsigneeInfoTable,2,0),"")
B3	=IFERROR(VLOOKUP(A3,ConsigneeInfoTable,2,0),"")
B4	=IFERROR(VLOOKUP(A4,ConsigneeInfoTable,2,0),"")
B5	=IFERROR(VLOOKUP(A5,ConsigneeInfoTable,2,0),"")
B6	=IFERROR(VLOOKUP(A6,ConsigneeInfoTable,2,0),"")
B7	=IFERROR(VLOOKUP(A7,ConsigneeInfoTable,2,0),"")
B8	=IFERROR(VLOOKUP(A8,ConsigneeInfoTable,2,0),"")
B9	=IFERROR(VLOOKUP(A9,ConsigneeInfoTable,2,0),"")
B10	=IFERROR(VLOOKUP(A10,ConsigneeInfoTable,2,0),"")
B11	=IFERROR(VLOOKUP(A11,ConsigneeInfoTable,2,0),"")
E2	=((D2-C2)*4)+4
E3	=((D3-C3)*4)+4
E4	=((D4-C4)*4)+4
E5	=((D5-C5)*4)+4
E6	=((D6-C6)*4)+4
E7	=((D7-C7)*4)+4
E8	=((D8-C8)*4)+4
E9	=((D9-C9)*4)+4
E10	=((D10-C10)*4)+4
E11	=((D11-C11)*4)+4

My Input Table (Mstr_GPD_Table): Must INSERT the # of rows per the above table first and add the info in colums A, C and D. Column B is a VLookup formula.

Excel Workbook
	A	B	C	D
1	Consignee Number	Consignee Name	Year	Quarter
2	75-2778918WV	Woodlands	2006	Q1
3	75-2778918WV	Woodlands	2006	Q2
4	75-2778918WV	Woodlands	2006	Q3
5	75-2778918WV	Woodlands	2006	Q4
6	75-2778918WV	Woodlands	2007	Q1
7	75-2778918WV	Woodlands	2007	Q2
8	75-2778918WV	Woodlands	2007	Q3
9	75-2778918WV	Woodlands	2007	Q4
10	75-2778918WV	Woodlands	2008	Q1
11	75-2778918WV	Woodlands	2008	Q2
12	75-2778918WV	Woodlands	2008	Q3
13	75-2778918WV	Woodlands	2008	Q4
14	75-2778918WV	Woodlands	2009	Q1
15	75-2778918WV	Woodlands	2009	Q2
16	75-2778918WV	Woodlands	2009	Q3
17	75-2778918WV	Woodlands	2009	Q4
18
19
Mstr_GPD_Table

Excel 2007

Cell Formulas
Range	Formula
B2	=VLOOKUP($A2,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B3	=VLOOKUP($A3,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B4	=VLOOKUP($A4,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B5	=VLOOKUP($A5,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B6	=VLOOKUP($A6,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B7	=VLOOKUP($A7,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B8	=VLOOKUP($A8,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B9	=VLOOKUP($A9,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B10	=VLOOKUP($A10,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B11	=VLOOKUP($A11,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B12	=VLOOKUP($A12,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B13	=VLOOKUP($A13,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B14	=VLOOKUP($A14,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B15	=VLOOKUP($A15,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B16	=VLOOKUP($A16,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)
B17	=VLOOKUP($A17,'[2007 - MASTER REPORT - EntryRpt.ACE.FCD.xlsm]Consignee Info'!A:B,2)

Thanks For Your Help In Advance,