Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question