Excel 2007 : Want to make a Order List

I have already upload the attachment here.

I want to make a order list but don't how to set the formula in excel, hope anyone can help me, it's important for me, please

1.) If the value in the Quantity (column D) is >=1, then will copy all the row to the Order (A13) if <1, skip it

2.) Will have the total weight after the order list was made, e.g. we have 47 kg in my list, then check back the cost from sheet "weight", that is $15 and paste it in somewhere in the order list

Hope these 2 question no need to use the VB program.

Thx everyone

Put this formula in A13

Please Login or Register  to view this content.

Then hold the CTRL and SHIFT keys down and hit ENTER. You will notice { } brackets appear around the formula. Then copy the formula down and across to column D.

Note: If you don't want VBA involved, you will need to allow for some blank rows underneath so that the cells will either fill or be "blank" based on your quantities....

Note2: If you make adjustments to this formula, you will have to reconfirm it with CTRL+SHIFT+ENTER each time, and then re-copy it over to the other cells.

Sorry, NBVC, can i help me one more
i modify the list now
if i use your formula into the list, how and where i paste it.

Now, i have 2 product list, and also the same condition, if the quantity column is >=1, paste the whole row to the "Order" Sheet

Thanks NBVC

See attached...

Formula in A2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied across 4 columns and down to row 17 (to cover all 8 items from each product sheet).

If you start adding more "products" you will need to begin thinking about using VBA instead... the formula will become bigger and less efficient, otherwise.

Try posting the question in the Programming forum with all details (do not add complications as you go along as you did with this thread)