|I am creating a First Article inspection 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.
If I have 3 parts to inspect with 4 different inspection points on each part I will need 12 rows generated labeled:
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
A1-E1 will be fixed
A2-E2 need to be inserted accordingly based on values of # of parts inspected and # of inspection points per part.