Filter question...
 

Hi,
i have a filter on the item numbers in a sheet.but when i use thi
filter,the row number changes for each sheet.i need to print out thes
reports.so the records that i get after using the filter should star
from row 1 instead of 456 or 345.....How do i do this ? do i have t
change any setting in the filter ?

Regard

--
Message posted from http://www.ExcelForum.com

Filter question...
 

Sameer,

Filtering doesn't move items around, it simply hides those that don't meet
the criteria. Printing a filtered sheet will print only the items showing -
just don't use inserted pagebreaks.

HTH,
Bernie
MS Excel MVP
"sameer27p " wrote in message
...
Hi,
i have a filter on the item numbers in a sheet.but when i use this
filter,the row number changes for each sheet.i need to print out these
reports.so the records that i get after using the filter should start
from row 1 instead of 456 or 345.....How do i do this ? do i have to
change any setting in the filter ?

Regards


---
Message posted from http://www.ExcelForum.com/