I'm hoping someone can help with an issue I have with a form.
I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.
Can anyone shed light on how to do this?
The dropdown box has been put in the form using the data validation function.
Bookmarks