Hello everyone! I'm super new to macros and scripts so please bear with me.
Scenario:
a. I have some data on a spreadsheet where the function that I'd like to happen are the ff:
- A save button (image), when clicked, saves the data from specific cells to a new sheet
b. All the next data that will be saved should NOT overwrite the previous row's data (right now, the save button works but when I save it again with a different entry on the cell, the new value overwrites the previous value)
c. The next saved data should move down to the next available row
Right now, this is the only macro script I was able to create (this is literally my first day on Macros!):
What I really can't figure out is what do I need to add so that new entries do not overwrite previous ones and just place the new values on the next available blank row.
Now, in your new code you appear to be referring to 3 different sheets and it's not really clear what you are copying from which sheet and where you are copying to.
Can you post in words what ranges/sheets you are copying/pasting from/to?
OMG!!! You are a life saver!!! It works!!! I'll try to search how the script works but its brilliant!!!
Just a few follow up questions though:
1. How do I add additional values to get from the Form tab?
2. Do you have any recommendation on how to create a "Clear" button, which resets the form once it's saved and the put default values in once cleared?
Bookmarks