I want to create a spreadsheet that has a drop down list that will let me select a customer and have the information pertaining to that customer filled in the spreadsheet at respective cells.
For example,
If I select customer A, then certain cells will fill in with a range of information that only pertains to that customer. While I can go on to Customer B and different information would fill into the same cells as the previous customer. Any/all ideas and help would be greatly appreciated.