Sorry the title isnt better.
My wife walks and house sits dogs and we are trying to set up excel so she can invoice easily. I have created a drop down list of the 12 different dog services eg Walk and Water, House visit, House sit, Board overnight etc, and that worls really well, however is there a way that when you choose one of these items from the drop down list excel will automatically show the charge for that service in another cell so that you dont have to input it manually.
I have created a drop down list of the prices which is sort of a halfway house at the moment.
Any help would be appreciated, thanks in advance!!
Bookmarks