Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

If Cells Have a value, copy and paste into new worksheet

  Asked By: Lourdes    Date: Aug 09    Category: MS Office    Views: 1736
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jacob Evans     Answered On: Aug 09

I'm not sure if this would help you.
Here is a link to my file PO_Master_12_26_07_S.xls
http://www.mediafire.com/?44zc3etr2yg

 
Didn't find what you were looking for? Find more on If Cells Have a value, copy and paste into new worksheet Or get search suggestion and latest updates.




Tagged: