• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Microsoft Office Excel Question - Filtering?

madmatt

Bow Down to the King
Political User
#1
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
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.
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies