|specific data from one sheet to another|
Hi, I've got to write a Macro to shift specific sales data that has a quantity of 1 from the Input sheet to the output sheet and i need the description and everything else in that row.
It looks like this:
Part No. DESCRIPTION CHF Quantity Price
XXXXX Blah Blah Blah Blah 99,999 1 =CHF*Quantity
YYYYY Blah Blah Blah Blah 99,999 0 =CHF*Quantity
I only need the Quantity 1 item and i need all the stuff that goes with it (Part no. Description, CHF, Quantity and Price)
I'd really appreciate any help here.