If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Re: auto copy from 1 sheet to other if condition met
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
Re: auto copy from 1 sheet to other if condition met
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.
__________________
If you've been given good help, use the icon to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc “Actually, I *am* a rocket scientist.” - JB (little ones count!)
icon to give reputation feedback, it is appreciated.
Linear Mode
