I tried seraching for this and maybe I was searching for the wrong thing but didn't come across anything that I thought would do the trick. This seems pretty simple but I can't figure out the excel way to do this.
I have a spreadhseet that has to be emailed back and forth between departments and one part of the spreadsheet has information I would like to auto populate.
It looks like this
Shop:
Street Address:
City, State:
Phone #:
Contact:
EMail Address:
I would like to have a drop down menu for the shop cell and have the other cells prepopulate with the correct information about that shop. There are about 30 shops total that I have all the information for, I just dont want to have to type it in everytime.
Please help!!
I have a spreadhseet that has to be emailed back and forth between departments and one part of the spreadsheet has information I would like to auto populate.
It looks like this
Shop:
Street Address:
City, State:
Phone #:
Contact:
EMail Address:
I would like to have a drop down menu for the shop cell and have the other cells prepopulate with the correct information about that shop. There are about 30 shops total that I have all the information for, I just dont want to have to type it in everytime.
Please help!!