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

VB Code to consolidate

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
0
jaymz69
Asked:
jaymz69
  • 3
  • 3
1 Solution
 
Rory ArchibaldCommented:
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.
0
 
jaymz69Author Commented:
That would sound like the easiest way.

How would I go about on a data lookup table?
0
 
Rory ArchibaldCommented:
You would have a lookup table with the actual route numbers in the first column, then the group names in the second column. Then in the source data you use an additional column with a formula like:
=vlookup(route_number,lookup_table,2,false)
to return the group for that route.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
jaymz69Author Commented:
How would I group in a Pivot Table
I would have to somehow setup every route consolidation
0
 
Rory ArchibaldCommented:
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.
0
 
jaymz69Author Commented:
OK so back to looking up lookup table.

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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