Having trouble writing a macro to move...

Microsoft Excel 2003 (full product)
November 3, 2010 at 06:45:20
Specs: Windows 7
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.


See More: Having trouble writing a macro to move...

Report •

November 3, 2010 at 07:13:01
You say that you are "having trouble". Does that mean that you have tried coding something?

Why not post what you have tried and we'll see if we can help you correct any errors?

Report •
Related Solutions

Ask Question