Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to print table values greater than a certain value
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to print table values greater than a certain value
Use autofilter on the hours_remaining column and select Custom then
enter your criteria (less than 25 in your example). Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
How do I have a data table display cell names rather than values? | Excel Worksheet Functions | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
how to pick from a range of table values | Excel Worksheet Functions | |||
Automatically print all page contents in pivot table. | Excel Worksheet Functions |