Microsoft Office Excel Question - Filtering?

[madmatt]

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.

 

[LeeJend]

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.

 

[Shamus MacNoob]

Or save the macro as an icon on menu bar

 

[jimi_81]

or put a form button on the spreadsheet itself and assign it to the macro

 

[madmatt]

Way beyond any thing I've ever done with Excel... I will give it a go and see what I can come up with.