Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BDP
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table macro to set print area and print details of drill down data Steve Haskins Excel Discussion (Misc queries) 2 December 28th 05 04:59 PM
How do I have a data table display cell names rather than values? raortiz99 Excel Worksheet Functions 1 November 9th 05 04:11 PM
Pivot table page filter not accepting multiple values. Workaround? jco Excel Worksheet Functions 2 September 25th 05 09:35 PM
how to pick from a range of table values jackoat Excel Worksheet Functions 5 August 2nd 05 08:50 PM
Automatically print all page contents in pivot table. David P Excel Worksheet Functions 0 February 21st 05 05:57 PM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"