T
T
Tikit2020-02-26 10:08:47
Google Apps Script
Tikit, 2020-02-26 10:08:47

Script to find data in a specific table from the active sheet, and transfer it to a specific table with a replacement?

Hello, please help me to solve the problem. I have a "Database" table that stores information, and I have a "Send" table where I enter information to send it to the "Database" table, but here's what I need. For example:
1. In the table "Sending", sheet "Inf", I select the line "197". It can be any string ;
2. I call the script;
3. The script should take data from cell "A197". Since I highlighted the string "197";
4. Find them in the "Database" table, "agreement" sheet, column "A:A". Let it be cell "A1203", it can be any found cell of column "A:A";
5. And if found.

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