selecting and pasting rows based on 1 cells value in a differnt worksheet

  • Thread starter Thread starter rainxking
  • Start date Start date
R

rainxking

I am having trouble trying to do the following:
I have alist of 500 items with information about each one in 5 columns
I can create a column or i can say "if this cell DOES NOT equal zer
than copy the 5 cells (or entire row makes no differnce) and paste tha
information in A2 of the next worksheet.

make sense? Here is an example to make it clear...

I select 5 items to sell so I put the price in the "price" column. No
i want excel to take all the items I am selling and populate th
invoice on the next worksheet. all other items will have a price o
zero.

dig it
 
i have 500+ rows of inventory.
sku, name, description, quanty, price

I only need to fill out a form with a few items. I'd like to make exce
put all the information into the next worksheet of item I am selling
The default price is zero. So, I figure if I can get excel to recogniz
when the price is not zero, to capture that item and it relate
information and dump into my worksheet (which is an invoice)

is that clearer
 
Back
Top