P
P
pavel_samael2021-07-09 17:44:08
Google Sheets
pavel_samael, 2021-07-09 17:44:08

How to transfer numbers from one sheet to another (and summarize) in google spreadsheets?

First sheet: There is a google table where in the first column there are 13 rows with drop-down lists (names in the list) and the second column is empty, you need to enter the number there yourself.
60e8620e2a058485039871.png
Second sheet: a column with names (not lists) (13 lines), and the second column is empty (the result will be written
60e862030ef0b169108076.png
there) ?
And if, let's say, on the first sheet in the first line, I select Ivan from the list, write him a number (let's say 10), on the second sheet, 10 should be added to Ivan, although he may be on the 5th line. How to make such a link?
And how to make it all happen when you click on the button, and after that the first sheet is cleared, but the second one is not?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question