LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default check lettered ticket number

my sheet1 had ticket book log numbers like

salesmanname,beginno,endno
janet 1 100
weber 101 200

I had no difficulty finding the salesman name when I enter number 78
ticket by VBA.
I mean till they numbered ticket books differently this year like

janet 1 100
janet 1b 100b
weber 101 200
weber 101b 200b

Now I can't reach janet when I enter ticket 78a. Any help ?

Thank in advance.
 
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
Excel columns are now numbered instead of lettered Kelly Excel Discussion (Misc queries) 4 April 21st 10 11:50 PM
Why are my columns numbered instead of lettered? valy Excel Discussion (Misc queries) 4 September 25th 09 09:42 PM
Random ticket number for raffle Matt Excel Discussion (Misc queries) 2 March 9th 09 07:21 AM
Need to find all instances of a ticket number in a spreadsheet DebraR Excel Worksheet Functions 3 January 3rd 09 05:40 AM
Columns are Numbered rather than lettered? Firman New Users to Excel 1 November 27th 07 07:22 AM


All times are GMT +1. The time now is 09:32 AM.

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

About Us

"It's about Microsoft Excel"