Extracting Data

[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)

 

[Bing]

This is how you use the advanced filter. On she spreadsheet
you have your list, and then a criteria list directly
above it. I.e

ITEM QTY DAYS TOTAL <<<<<criteria list

0

ITEM QTY DAYS TOTAL <<<< actual data list
1 3 13 39
2 3 2 6
0 0 0 0
0 0 0 0
4 6 44 26
5 6 4 24
5 6 4 24
6 6 4 24

In the advanced filter select the actual list as your list
range, ans the criteria list as your criteria. Select copy
to another location, and select where the result should
appear.

Click OK and thats it.

Hope that helps

-----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)