auto copy from 1 sheet to other if condition met

**starlover123** · 07-04-2009, 07:25 AM

is it possible to use excel to do the following:
if the value in A1 > 1 in sheet 1, then recreate row 1 to sheet 2 in row n.
thank you so much

**Rahul Nagar** · 07-04-2009, 07:48 AM

Hello starlover123,

Can you please attached sample file for more details.

Regards
Rahul

**starlover123** · 07-04-2009, 08:48 AM

thanks for reply
here is what i am trying to do, I want to generate a final sale list. so if I entered quantity that's greater than 1 item in the order sheet. I have to copy the same row from the order sheet to my final purchase sheet.
example:
in the order sheet:
item quantity price
apple 10 9.9
pear 0 0
orange 1 1

then in the final sheet it will show
you ordered:
apple 10 9.9
orange 1 1

**JBeaucaire** · 07-04-2009, 09:25 AM

I would us a technique like shown in this sample workbook. On the "ITEMS" page is a complete list of items and a column for ordering QTY of each item. As values are entered into the QTY column, notice the values in column A that appear. That's our index "KEY" and each entry creates a unique number.

Those numbers are used on the INVOICE page to draw all the matching info for that row onto the invoice. Very nice.

Hopefully this helps.