Hello,
I'm looking to improve the sheet in attachment and I learned quite a bit on my own, but now I'm stuck. So I'm calling out for help!
The sheet I've created has to provide me with a cause and solution whenever I select an error.
It works as follows:
The cell A2 has to return a dropdown list, depending on which "direction" I need. I used an indirect formula (linked with cell E2)
Whenever I select a value from the dropdown list, another Indirect formula has to populate cell B2 and so on.
What I'd like to know is if I can create a macro to select the cause of error and action from the drop down list returned in cell C2 & D2
Or if another solution exists since I'm not sure the macro will work.
Help? Please?
Krgds,
A newby with a headache...
Bookmarks