Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Okay, You guys were so awesome helping me with another problem earlier today
that I thought you would surely be able to help me with this; I have an Excel file that contains a few different sheets. These sheets are used for managing scheduled maintenance on a particular airplane. The first sheet (named "MSR") has header general information in rows 1-7. Then all rows below that point list each inspection or other schedule maintenance requirement. each row contains a description, interval (12 months or 200 hours for example), date & hours when accomplished, next due, and time remaining until next due. In the far right column (which is M in this case) I have a formula that will display the word "DUE" in that cell if the time remaining for that item is less than 90 days or 50 hours. So what I want to do is to populate on another sheet (named "DUE LIST") starting at row 8 with each row from the "MSR" sheet that has the word "DUE" displayed in column M. How would I go about accomplishing this? Many thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1 | Excel Discussion (Misc queries) | |||
How to populate prices in sheet two based on cost in sheet one | Excel Worksheet Functions | |||
How to populate one sheet with data from another sheet | New Users to Excel |