| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering a spreadsheet
hi, first of all i don't know if it's possible to do this with excel....
i have a liste wich have 4 colums column 1 article number and name (AAA-305 - cli- a/c keeprite) column 2 article selling price (500.00$) column 3 article cost price (250.00$ column 4 article last change date i have about 2000 items on this list and want to be able to print just 500 items how could i have the selected lines transferd to another page to be printed as another list -- thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
filtering a spreadsheet
Look at advanced filter in help, it does what you want.
Or take a look at http://www.contextures.com/xladvfilter02.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sebas" wrote in message ... hi, first of all i don't know if it's possible to do this with excel.... i have a liste wich have 4 colums column 1 article number and name (AAA-305 - cli- a/c keeprite) column 2 article selling price (500.00$) column 3 article cost price (250.00$ column 4 article last change date i have about 2000 items on this list and want to be able to print just 500 items how could i have the selected lines transferd to another page to be printed as another list -- thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering Multiple Paragraps on Same Spreadsheet | Excel Worksheet Functions | |||
| Filtering data to new spreadsheet | Excel Discussion (Misc queries) | |||
| Excel 2003; spreadsheet with filtering; deleting rows | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
| MY SPREADSHEET IS NOT FILTERING CORRECTLY | Excel Discussion (Misc queries) | |||
Linear Mode
