thombill
05-17-2006, 12:26 PM
Help! I have tried to come up with a easy way to accomplish my task, have tried to use filters, conditional statements. Just can't get it to function.
Problem:
I have two lists of items (Column A) & (Column B). In Column A I have a list of 3 companies but each company is listed several times, Column B is a list of the account codes for the three companies. They are arranged in rows, so company A, B, and C have multiple account codes.
I am trying to have a list that my folks can select there company name and then in the next box only see their applicable account codes. I am trying to keep this simple.
I have attached an example of the accounts, just don't really know where to start.
3157
Even a couple of ideas of a better direction would be appreciated.
Thank you in advance.
:banghead:
Problem:
I have two lists of items (Column A) & (Column B). In Column A I have a list of 3 companies but each company is listed several times, Column B is a list of the account codes for the three companies. They are arranged in rows, so company A, B, and C have multiple account codes.
I am trying to have a list that my folks can select there company name and then in the next box only see their applicable account codes. I am trying to keep this simple.
I have attached an example of the accounts, just don't really know where to start.
3157
Even a couple of ideas of a better direction would be appreciated.
Thank you in advance.
:banghead: