Clear 2 ranges of cell data when value is changed in primary drop down (no programming)

Hello All,

Please find attached excel file. I want to empty the data from ranges D19-D38 and G19-G38 whenever I change the value at cell D15.

E.g. I first choose "ST/L2101OT - Standard Barcode Swing Ticket" at cell D15 and choose some values in range D19-38 and then also choose some values in range G19-38. Now when I change value at D15 to "ST/L2107OT - Standard Barcode Swing Ticket" , I want the values in ranges D19-38 and G19-38 be emptied automatically.

How can I do this not using programming? Thanks!!

You can't. You'd need to use programming. It would be a very simple code, Are there formulas in any of the cells in G19:G38, D19:D38?

there is no formula in these cells, but they are drop down menus. Pls find my attached excel file in my first post. Thanks

Same answer, there's no way to do it with formulas. Sorry