Inserting Rows based on Values

Microsoft Office excel 2007 home & stude...
August 9, 2010 at 07:58:52
Specs: Windows XP
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.

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


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-E1 will be fixed
A2-E2 need to be inserted accordingly based on values of # of parts inspected and # of inspection points per part.


See More: Inserting Rows based on Values

Report •

#1
August 9, 2010 at 08:44:39
Thanks for sharing.

Is there something you want from us?


Report •

#2
August 9, 2010 at 09:03:17
Yes, I need help with what I need to do to be able to Generate rows on Sheet 2 from Data in Sheet 1.

I apologize for not being specific enough.

It was a question not a statement.


Report •
Related Solutions


Ask Question