try using datafilterautofilter

--
Don Guillett
SalesAid Software

"kcowan" wrote in
message ...

I am trying to figure out a way to print only selected portions of a
spreadsheet. The data gets updated weekly and needs to be printed, but
only the items with certain criteria.

The spreadsheet contains all managed properties in rows (there are 300
properties), and only the properties with vacancies need to be printed.
Is there some sort of toggle or check box I can put at the beginning or
end of each row to tell Excel to print? Using the control|select with
the mouse is not ideal as there are not too many changes each week.
Sorting is not ideal as there is a header row for each property.

1 property 123 description
2 unit #bedrooms rent available
3 A 2 1000 now
4
5 property 555 description
6 unit #bedrooms rent available
7 A 2 1000 2/1/06