Thanks Nigel,

I really need the rows copying to a separate sheet because 'Sheet2'
contains other information about the order, such as customer name,
order total, discount etc. etc. (for this reason the macro needs to
copy to the next blank row in sheet2

Any more ideas apprecaited....

Jon


On Dec 28, 11:18 am, "Nigel" wrote:
You might consider using an autofilter placed in the header row, then use
the filter control (custom) in column E and select values greater than 0,
the filtered list can be printed directly as only visible rows will be
printed or copied to another sheet as required.

No VB involved but if you were to use the macro recorder as you apply the
above steps it could then be assigned to a control button if required, you
might also include the printing step in the macro to automate the whole
process, including resetting the filter and clearing values in column E for
the next order!

--
Cheers
Nigel

wrote in glegroups.com...
Hi,

I'm completely new to VB and excel but I need a macro that does the
following, just to give you the background its a picking list that
lists our entire product range but to cut down on wasted paper and
picking errors we only want to display and print items that are
actually required by the customer:

(column letter and title shown)
A PART NUMBER
B DESCRIPTION
C SIZE
D PRICE EACH
E QTY REQUIRED
F QTY DELILVERED
G £

I need a button at the end of the document then can be clicked when the
user has finished inputting the "QTY REQUIRED" in row 'E' that will
scan the complete sheet for rows where the value in row 'E' is not
empty (<""), i.e. where a QTY of the item is required... Then copy the
row A-G to sheet 2 (from sheet 1) - ready for printing and picking.

Any help would be greatly appreciated!

Cheers,

Jon