Hello!

I hope someone can help. I am looking to create a customer database, which has a list of around 300 customers on one tab. From there we offer around 30 different services, (which have tabs of their own), but not every customer gets the same services. I need a database that I am able to print which customers get each service. And this is something where I need to print the services separately, and have notes for each customer, per service.

I am thinking have a main tab with all the customers, then additional tabs for each service we offer, and a formula or a way to reference the customer tab and the pertinent services. Then being able to sort that list alphabetically by customer name. And throughout the season, we have customers that no longer need the service, or adding customers.

I am not familiar with VBA or Pivot Tables, but definitely willing to learn, if that is what it takes.

I hope this makes sense.

Thank you in advance for your help!