Intricate Row Inserting Code needed

[CYB0RG]

I am creating a First Article report generator and I have Sheet 1 as the place where all the numbers are entered for Sheet 2 to compile accordingly.

I need help with what I need to do to be able to Generate rows on Sheet 2 from Data in Sheet 1.

_____________________________

SHEET 1
A1 is listed as "Total Parts inspected"
B1 is where the data will be entered
A2 is listed as "# of Inspection points"
B2 is where the data will be entered

SHEET 2
A1-F1 will be fixed headers
A2-F2 need to be inserted accordingly based on values of # of parts inspected and # of inspection points per part.

EXAMPLE
If I have 3 parts to inspect with 4 different inspection points on each part I will need 12 rows generated labeled:
A1
A2
A3
A4
B1
B2
B3
B4
C1
C2
C3
C4
THE (A1,B1,C1 etc.)labeling will be listed in the "ZONE ITEM #" row starting at "A2".

Here is a link to the saved EXCEL workbook for a better understanding of what I'm trying to accomplish.
http://www.mediafire.com/?494u80ubsiy6bmw


Thanks in advance for any help received.

CYB0RG

 

[CYB0RG]

bump? Help needed.