Results 1 to 1 of 1

IF, Vlook, Filter sorting and copying

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question IF, Vlook, Filter sorting and copying

    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
    Attached Files Attached Files
    Last edited by A-Ibraheem; 09-19-2012 at 03:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1