LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Please assist...

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't remember....please assist Latina Excel Discussion (Misc queries) 4 February 8th 07 08:20 PM
SumIf - More then 1 criteria - Please assist Nir Excel Worksheet Functions 8 October 26th 06 03:21 AM
Assist with Match Dates rhani111 Excel Discussion (Misc queries) 4 August 14th 06 11:19 AM
Formula Assist [email protected] Excel Discussion (Misc queries) 3 June 7th 06 12:37 AM
Please assist Bubba_James Excel Worksheet Functions 1 September 9th 05 06:28 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"