Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question