I have a worksheet with several drop down lists in them. What I would like to be able to do is insert a predefined value into the next cell depending on which list item is selected in a drop down list.
Example, in the drop down list is a list of stores, and there are budget values defined for each store so if I select store#3 I want this month's total wage bugdet for store#3 to be inserted into the next cell. The figures that I want inserted exsist in the workbook, over in column AB.
Thanks,
Neil.
Bookmarks