S
soke2001
Hello everyone...n00b question.
I'm using Excel 2003 to split up a daily spreadsheet between me and 2
of my peers. We split the orders based on the last 2 characters of the
order. The orders are all 7 digits and all numerical. Exp... 3215453.
For example... my number range is 00-33.
Every morning I have to scroll through the spreadsheet and manually
select my orders to obtain my daily workload, which can take up to 40
minutes. I tried using auto-filter with wildcards * & ?, but they
don't work. I'm typing my custom filter values as follows ?????33 and
*33, but they don't work. Are they supposed to work on numbers?
There has to be an easier way... please assist.
Thanks in advance!!
Javier Cortes
I'm using Excel 2003 to split up a daily spreadsheet between me and 2
of my peers. We split the orders based on the last 2 characters of the
order. The orders are all 7 digits and all numerical. Exp... 3215453.
For example... my number range is 00-33.
Every morning I have to scroll through the spreadsheet and manually
select my orders to obtain my daily workload, which can take up to 40
minutes. I tried using auto-filter with wildcards * & ?, but they
don't work. I'm typing my custom filter values as follows ?????33 and
*33, but they don't work. Are they supposed to work on numbers?
There has to be an easier way... please assist.
Thanks in advance!!
Javier Cortes