I have the following situation and trying to solve using vba.
I have few sentences in "sheet1". one in cell "B3" and other in cell "B9" and i have placed two command buttons named "Insert" and "clear" against each sentence, so that when ever "Insert" button is clicked the respective sentence will be copied in cell "D1" of sheet 2, and "clear" button to "clear" the respective sentence. When more than one sentence is inserted i am trying to have one line gap between them.
Please help with the code that is to be written in "Insert" and "Clear" buttons.