LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel - Wildcards

All, everyday at work I pull a spreadsheet with over 1000 orders that
are worked by me and 2 other ppl. I have a column on the spreadsheet
that lists the order numbers (7 numerical characters). The three ppl
in my department divide the orders based on the last 2 digits of the
orders; 1st person = 00-33, 2nd person 34-66... etc. My questions is:

What is the easiest way to automate filtering only my orders and
copying them into a new file? I tried the Auto-Filter mode and tried
using wildcards (* and ?) to replaced the first 5 numerical characters
of the order, but nothing happened. Please assist. I'm using Excel
2003.

Thanks!

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
Wildcards and if Arlene Excel Worksheet Functions 3 June 21st 07 12:05 AM
Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell Keith Excel Discussion (Misc queries) 3 December 22nd 06 02:27 PM
use of wildcards italiavb Excel Worksheet Functions 5 July 14th 06 05:48 AM
Can wildcards be used in the Logic Test of an Excel "IF" function? Monte Excel Worksheet Functions 3 August 15th 05 01:25 PM
How can I find strings of wildcards in Excel? Nick M Excel Discussion (Misc queries) 2 December 20th 04 05:59 PM


All times are GMT +1. The time now is 09:31 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"