I need help inserting a row below everytime i select from a dropbox.
i.e whenever i make a selection from the dropbox, another row will be inserted below it.
however a row should not be added if a selection is already made on that row.
so when i pick a selection from cell 3B, a whole row will be inserted below 3B.
but when i make a selection from cell 3C, since there's already a value in 3B, a new cell would not be inserted.
the row should still be within the 2A merged cells.
pardon if my description is too vague. i'm an excel noob. i've attached a picture and the excel file hope it helps. =X
Many thanks!
Bookmarks