I'm trying to build a basic order form where I can take orders from clients and
fill out an
quantity from a long list of products, only some of which will be ordered at one
time. I would
like to write a Macro in VBA where, at the end, it could cut and paste only the
products
ordered into a new worksheet. I'm thinking that I could use an if statement to
ask if the
quantity is >0 and if so copy and paste that entire row, which, description,
quantity, price
etc. in to a new worksheet. I'm guessing I will have to use some kind of 'for'
or 'while' loop to
copy the next line with a value (an order quantity greater than zero) to a new
line on the
worksheet. I'm new to VBA programming in Excel so any comments or suggestions
would be
appreciated. I've programmed in other languages before so I'm somewhat familiar
with
concepts and terminology.