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

[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

 

[Trevor Shuttleworth]

make sense? No, not really ;-(

 

[Debra Dalgleish]

You can use an AutoFilter to hide the rows that have a price equal to
zero. Copy the visible rows, and paste them on the invoice sheet.

There are instructions in Excel's Help, and on my web site:

http://www.contextures.com/xlautofilter01.html

 

[rainxking]

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