I am working on an order form, and i have two sheets in the workbook. the
first sheet, materials, is the input sheet. it lists a bunch of materials in
our inventory and in the same row as any given material is the input for
quantity.

here is a picture of what i am describing:
http://img146.imageshack.us/img146/3...estion1bu0.jpg

Now, what i want to do is have the string of text and quantity copy over to
another worksheet (named PROPOSAL). Seems simple, but as you can see in the
first picture, not every item will be purchased. and the list is over 400
rows long. Of course they can be individually copy/pasted, but since this
will be done a lot i am looking for a quick solution to make them switch over
without a copy/paste.

this is the desired result:
http://img354.imageshack.us/img354/3...estion2nw0.jpg

I have thought of this problem in terms of lookups, arrays and even macros,
but they seem so complex (at least based on my knowledge of the three).
Anybody know a simpler solution? Thanks for any advice.