Hi Tigers
I have used some formulas to create the attached schedule, it worked like a charm , the issue I am facing now is the filtering and sorting of information, when I select a name from the Manpower drop list and sort the schedule by the start date it through the schedule out of whack and information goes out of order, what I am trying to do is print out a schedule for individual manpower and filtered by the start date rather than the ship date,
I am thinking of creating another book that pulls and filter the information and segregate them by months each tab on the new book for one of the names on the manpower list and flitted by the Start date not the ship date, can anyone help me with a formula to filter, copy and sort in another sheet
the size of the original schedule is more than 10,000 rows, had to reduce it to be able to attach it
Please let me know if I missed anything
Thank you for your help and support
Cheers,
AI
Bookmarks