close

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.

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

Hope this helps.

Pete

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()