Hello everyone,
My first post here- I have seacrched through the archives without success- am hoping someone can help with this basic query.
I have set up a fairly standard table with Company name, contact, details, website etc. and I need a column for industry classification. Using auto Filters, this works perfectly when each company only has one industry classification, but I cant figure out how to do this for multiple classifications. That is , I cant work out how to enter the data, nor can I work out how to make it filter for me.
For example, Company A might be classified as a General Insurer, Car Insurer, Boat insurer, Special Items Insurer etc. I need to be able to search by Industry class so I can pull down General Insurer , for example, and see all the companies that fit this category, or perhaps just search for Compnay A to see all the types of insurance it offers.
Any suggestions would be greatly appreciated.
Thank you
My first post here- I have seacrched through the archives without success- am hoping someone can help with this basic query.
I have set up a fairly standard table with Company name, contact, details, website etc. and I need a column for industry classification. Using auto Filters, this works perfectly when each company only has one industry classification, but I cant figure out how to do this for multiple classifications. That is , I cant work out how to enter the data, nor can I work out how to make it filter for me.
For example, Company A might be classified as a General Insurer, Car Insurer, Boat insurer, Special Items Insurer etc. I need to be able to search by Industry class so I can pull down General Insurer , for example, and see all the companies that fit this category, or perhaps just search for Compnay A to see all the types of insurance it offers.
Any suggestions would be greatly appreciated.
Thank you