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

Do you have to post in all newsgroups? Multiposting is considered really bad
in these groups (in all newsgroups).

http://www.cpearson.com/excel/newposte.htm


--

Regards,

Peo Sjoblom

"soke2001" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>