Storing multiple information from one formula

[kellenhaskell]

I am somewhat new to excel and am running into a problem. I work for an interior wood door company and am working on putting together a spreadsheet that will calculate parts lists based off a simple input of door width and height. I have it all set up so that when you put in 36X96 all cells change to reflect that door. What i would like to do is create it so that i can put in 36 or 34 or 32 or 30 and have them each show that parts list accordingly. So that when a salesman needs to process work he can simply just put in all sizes of doors plus quanitys and it will generate multiple cutlists off of my one set of formulas. The way its set up now i have multiple cut lists but as i change the number from 36 to 34 all other cutlists reflect only the latest input. so my cutlist for 36 is actually one for 34.

So im curious to if there is a way i can store the output each time i change the number? or something similar to it that will acheive the same thing.

THANK YOU

[shg]

How about posting the workbook you have now?

[mhuston]

Try this. Selecting from the dropdown populates the next fields with data from the ProductInfo page. The dropdown is populated from a range called DoorSizes, which is also on the Product Info page.