I have an Access database with my customers information that does not change very often. Throughout my season I have a variety of different set of work depending on the season basically breaking down to 3 different seasons that I would like to store in excel. Now each of these 3 seasons will hold different information for each customer and will not relate to each other and only to the database.
Is there a way that I am able to begin filling out the customer name in excel and then it can auto fill all the basic customer information into table to avoid having to fill out all the information for each customer 3 times a year?
Any help is greatly appreciated in advance.
Is there a way that I am able to begin filling out the customer name in excel and then it can auto fill all the basic customer information into table to avoid having to fill out all the information for each customer 3 times a year?
Any help is greatly appreciated in advance.