Hi,
I have a drop down list in column G, a dependent list in column H (using INDIRECT) and
another dependent list in column I (using SUBSTITUTE). 1000 Rows.
I'd like to clear columns H & I when column G is changed and also clear column I when only
column H is changed.
Any help appreciated
thanks
Jon