<div>
It would be useful to see a data sample. I think you just need a lookup table, but it's not clear from the question. You could also simply group those items in a pivot table if that works for your needs.
</div>


It would be useful to see a data sample. I think you just need a lookup table, but it's not clear from the question. You could also simply group those items in a pivot table if that works for your needs.

<div>
That would sound like the easiest way.<br />
<br />
How would I go about on a data lookup table?<br />

</div>


That would sound like the easiest way.

How would I go about on a data lookup table?


<div>
How would I group in a Pivot Table<br />
I would have to somehow setup every route consolidation<br />

</div>


How would I group in a Pivot Table
I would have to somehow setup every route consolidation


<div>
If you have a lot of them to group, use a lookup table and formulas. Doing it in the pivot table would be a real pain.
</div>


If you have a lot of them to group, use a lookup table and formulas. Doing it in the pivot table would be a real pain.

<div>
OK so back to looking up lookup table.<br />
<br />
thanks<br />

</div>


OK so back to looking up lookup table.

thanks


<div>
<div class="content wysiwyg-content">
I have a ODBC query bringing in order header files on the orders by routes.<br />
but there are three companies with three routes that equal one.<br />
<br />
Route: 1A, 2B, 2C<br />
<br />
I don't want to have three filters on the routes I would like to have a lookup or something so they can be consolidated as one in the view
</div>
</div>


I have a ODBC query bringing in order header files on the orders by routes.
but there are three companies with three routes that equal one.

Route: 1A, 2B, 2C

I don't want to have three filters on the routes I would like to have a lookup or something so they can be consolidated as one in the view

VB Code to consolidate

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.