Need to print table values greater than a certain value

B

BDP

I have a table with about 150 rows, each row for a single helicopter part
(time in service for the individual part, etc.). When I update the
helicopter total airframe time all the individual parts times update
automatically and each part has a service life that decrements to a point
where overhaul/replacement is required.. I need to find a way to have a
report print at the bottom of the spreadsheet that lists only those parts
with less than a specified number of service hours remaining (say, less than
25 hours remaining).

Any ideas???

Thanks.
 
P

Pete

Use autofilter on the hours_remaining column and select Custom then
enter your criteria (less than 25 in your example).

Hope this helps.

Pete
 
Top