• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

Extract information based on left 2 characters

Hello Experts!

Have a worksheet that has a field called "route ID"  this is made up of 2 alpha characters and 4 numeric characters or it could be 5 numeric with the left 2 being the identifier.  It is always the left 2 characters.  What I am hoping to do is to have a msgbox ask which departure we require and from that extract information in column a to d on a new worksheet based on the answer from the msgbox AND only those that match the left two characters of those ID's that match those in a table.  I've attached the simple spreadsheet and some additional information to help clarify what I need.  

Thanks in advance.

spudmcc (Andy) Book12.xlsx
1 Solution
Rory ArchibaldCommented:
How's this? Change the value in the list in B1 and it will create a new sheet and output to it.
spudmccAuthor Commented:
Thanks so much!  I appreciate your speed in providing a solution.  It works great!


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now