Microsoft Office Excel Question - Filtering?

Discussion in 'Windows Desktop Systems' started by madmatt, Jan 25, 2006.

  1. madmatt

    madmatt Bow Down to the King Political User

    Messages:
    13,312
    Location:
    New York
    Version 2003 (SP2)

    One of my users gets a Excel Spreadsheet with order data once a week. A former employees used to filter this data out into different tabs.

    Here's the tab structure.

    Order Data (the main sheet)
    Outside Vendor (a sheet that only shows orders that we are waiting on someone else)
    Job (a sheet that only shows internal job numbers)
    ...and so on...

    In the Order Data tab there is a column called Status. Status can be several different things. e.g. "JOB ..." or "BMC ...."

    If it says "JOB ..." we want it to go to the Job tab. If it says "BMC ..." we want it to go to the Outside Vendor tab.

    Problem is that there are several different vendors. The employee said she saw the former employee do this several times and he only clicked a few buttons. Can anyone shed some light on this for me? Thank you.
     
  2. LeeJend

    LeeJend Moderator

    Messages:
    5,291
    Location:
    Fort Worth, TX
    Macro with an If statement to check the order type and then cut and paste commands to move the order to a new sheet (tab). There are commands to use in the macro that will take you to the first blank entry space (row or column) on a sheet.

    (or copy and paste to retain the original)

    Save the macro as a keystroke combo.
     
  3. Shamus MacNoob

    Shamus MacNoob Moderator Political User

    Messages:
    4,199
    Location:
    L'Ile Perrot Quebec
    Or save the macro as an icon on menu bar
     
  4. jimi_81

    jimi_81 Moderator Political User

    Messages:
    820
    Location:
    Stoney Creek, ON, Canada
    or put a form button on the spreadsheet itself and assign it to the macro
     
  5. madmatt

    madmatt Bow Down to the King Political User

    Messages:
    13,312
    Location:
    New York
    Way beyond any thing I've ever done with Excel... I will give it a go and see what I can come up with.