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 |
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 |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com