GG Sheets Macros

[CSolis]

Hello. First time here. I'm having issues with a GG Sheets Macro I'm working on. Essentially, the macro consist of taking information entered on Tab A and pasting/saving it onto Tab B. However, any new information I'm entering is overwriting old entries, so the Macro is not skipping a pre-filled row as it should be. Any ideas on what action I missed during the Macros process or a line of code/script that I could use so when saving new information the macros jumps on the next blank row? Thanks!

[janmorris]

Hi CSolis,

A macro is just a simple type of Apps Script, and it is designed to replicate a repetitive procedure. For anything more complex will require a properly written Apps script that is designed for the task.

Is there anything in your macro about "getLastRow" ?
If not, that right there is the main part of your problem.

[CSolis]

There's no "getLastRow" and that's the issue I'm dealing with. To be honest. I'm not sure how to go from there I've been looking around and can't seem to find anything related to the subject or similar tot he same issue I'm facing.

[janmorris]

Developing a suitable apps script will require complete understanding of the source data structure:

* whether there are formulas, or dropdowns that can interfere with finding the last row, and in which columns they are located in (workarounds include using arrayformulas wherever possible, and where dropdowns are filling a column it requires looking for the last row on another specific column that has complete data without blank cells, like an entry ID, etc)
* if there is capacity to add a new column to mark when something has been appended (so that the source data isn't duplicated in successive runs of the script)
* etc.