P
P
PiShim2021-03-25 12:29:09
Google Sheets
PiShim, 2021-03-25 12:29:09

How to copy rows with a shift down when changing from one document to another?

Good afternoon.
I don't know how to accomplish this task. The essence of the problem is this. There is document A, a new sheet is created in it every day and changes occur on these sheets every day. It is necessary that lines with the data changed in them be copied to document B, and each new change copies the line and places it below. That is, in document A there are lines
1 first name last name
2 Petr Petrenko
3 Ivan Ivanov
, they are copied to document B, but when the name Peter was changed to Petrovich (or any event), for example, this change was caught and approximately the following records were created
1 first name last name
2 Petr Petrenko
3 Ivan Ivanov
4 Petrovich Petrenko
I don’t even know how to do this

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Victor L, 2021-03-25
@Fzero0

There are simple triggers Triggers
You need to hang onEdit (e) - it is launched when the user changes the value in the spreadsheet
and get what has changed
.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question