I have a problem with a macro that I have used in my spreadsheet.
The problem is that when I use a macro I have created to copy and paste cells onto another sheet it is constantly overwriting the data when it needs to be constantly adding new information every time that the button is clicked, I need the button to paste below what has already been pasted when the button has previously been clicked.
My question basically is:
What coding do I need to insert into the macro to make it paste into the next available blank cell and not overwrite what has already been done?
Bookmarks