Populate sheet with lines from another sheet
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! |
All times are GMT +1. The time now is 08:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com