Extracting Data to seperate location

[Guest]

I am composing an invoice for my rental business. I have set up a sheet with all the items that I rent. The cost of each item is determined by the number of items time the number of days rented. I would like to extract, to a separate location, only the items that were rented plus a few category headings. The names of my Columns are as follows:
ITEM QTY DAYS TOTAL
I was trying to use the Auto Filter but that doesn’t seem to have the option of putting the data in another location. I can’t figure out how to do the advanced filter. I would like to extract every row on the list where the QTY is greater than zero and paste them into another location where I will have our logo etc at top of letter size page and other info at bottom. (I can enter a transparent number in the QTY row so the categories will show up)

 

[Peter Atherton]

Tom Ogilvy has written an excellent macro to extract
filtered data into a new sheet.

You can find this at Debra Dalglieshes site:
contextures.com

Regards
Peter

-----Original Message-----
I am composing an invoice for my rental business. I have

set up a sheet with all the items that I rent. The cost of
each item is determined by the number of items time the
number of days rented. I would like to extract, to a
separate location, only the items that were rented plus a
few category headings. The names of my Columns are as
follows:

ITEM QTY DAYS TOTAL
I was trying to use the Auto Filter but that doesnâ?Tt

seem to have the option of putting the data in another
location. I canâ?Tt figure out how to do the advanced
filter. I would like to extract every row on the list
where the QTY is greater than zero and paste them into
another location where I will have our logo etc at top of
letter size page and other info at bottom. (I can enter a
transparent number in the QTY row so the categories will
show up)