I have an excel sheet that our salesman need to use for order requests. I have created a drop down for descriptions and to auto-populate the daily weekly and monthly rental rates.
There are multiple branches that all use same equipment but have different rental rates. How can I achieve the proper rates when a choice is made in the drop down?
Worksheet A has a cell that allows the user to select the Branch.
Worksheet B contains rows of equipment choices:
Cat Class Item Description Branch Daily Price Weekly Price Monthly Price
I've been able to work with my IT guy a little, and he was able to get the rates to pull in using the formula , however he said he can only get this to work by saving a new file order sheet/excel file for each branch?
Any help in getting this "automated" would help... Hopefully this explains things further?