On my worksheet, i have around 15 different dropdown lists that all work off variable inputs.
I have a Working VBA Code that allows me to clear contents of one cell if the input is changed, but as a VBA novice i cannot adapt it to work with different inputs and outputs. I have tried searchign the forums, but can only find references to where people want to clear one cell.
This is what im working with at the moment but want to add in more variables such as if "D4" is changed then clear "E4:H4" same with D5- E5:H5 ect
Any help would be apriciated.
Also there are other parts in the spreadsheet that i could use this on, but again on the same page so eg, if B4 is changed then clear B5, so all of the changes are not in a linear fashion.
Thanks in advance for anything you can do to help.
Bookmarks