Nov 19 2022 09:37 PM
is there a way in a macro to select the last cell in an array, then move down to the next empty cell, paste the data in that cell, which is a different cell each function. When recording the macro, the data always wants to paste to the same cell. It needs to paste below the current data and add to the list, not replace current data. Can anyone help if i have explained it right... I hope. Thank You