- Joined
- 5 Apr 2002
- Messages
- 13,314
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.
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.