I have an interesting project to work on and I am not quite sure what the best method to attack it would be.

I have two sheets.... 'Footages' and 'Breakdown'

Footages is a general line item description with footages for each floor, with the floors laid out in columns starting with 1 thru X

Breakdown pulls the description and the total footage from the Footages sheet.

What I need to do is dynamically create line items in the Breakdown sheet per floor. Example: If I enter on the Footages page, Wall Type A, with 100 feet on each of the first 3 floors, I have 300 total feet for Wall Type A but on my Breakdown sheet I need it pull the total line, then recognize something in the 1st floor column and add a line item below the total and do the same for the 2nd floor, the 3rd floor, and so on...

Make sense? Thanks