Is there a formula for this?

  • Thread starter Thread starter Roberta
  • Start date Start date
R

Roberta

Thank you advance for any help on this!
Example: worksheet "A" has
"qty" "description" "price" "extension"
1 widget 5.00 5.00
whoosit 7.00 .00
2 whatchit 2.00 4.00

I would like a formula to look at the "quantity", and if
it is greater than zero, I would then like each cell's
contents to transfer to a corresponding cell in the
another workbook. Problem is I would like it to transfer
it row by row without skipping.

End result:
"qty" "description" "price" "extension"
1 widget 5.00 5.00
2 whatchit 2.00 4.00

If you can do this, I would think you are brilliant.
Roberta
 
This might work for you:

Select your data (the Qty column is enough).

then data|Filter|Autofilter
use the dropdown to show greater than 0
Copy those visible cells and paste to where you want them.

Not a formula, but pretty quick.
 
Back
Top