Hello everyone.
I spent few hours looking for a macro that works for me, but I haven’t found exact match this far.
Here is my intention:
My data range is H4:H40, where in each datavalidated cell I can choose between different text strings. What im trying to, is I need „add new row“ option to my datavalidated drop-down list, that inserts new full row below currently selected cell and if „add new row“ is selected, it leaves current cell blank.
Any information would be helpful.
Bookmarks