Hi guys.
Feeling my head is exploding because I can not find a solution for what I want.
I have a mastersheet with data with approx. 1000 customers in column A and approx. 50 columns of data.
I want to have another excel sheet where I can:
Feeling my head is exploding because I can not find a solution for what I want.
I have a mastersheet with data with approx. 1000 customers in column A and approx. 50 columns of data.
I want to have another excel sheet where I can:
- Search for a customer
- If not found, add new customer
- If found, retrieve all the data for the customer in different columns and row
- The opportunity to edit this information
- The opportunity to save new informastion to the mastersheet, so that it will show correct informastion next time I search for the customer