Hello all,
I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets.
When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the next 3 columns however I am currently struggling to achieve this.
Any help would be much appreciated
I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets.
When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the next 3 columns however I am currently struggling to achieve this.
Any help would be much appreciated