I have a registration form that adds a new row into tab=Order_Form with Company Info and Contact info Email. Based on such received data (the system will generate a unique Client_Id). I like to Add a new row to tab=companies to add this new company info & tag it with this new Client_Id. Add a new…

The concept would be the same. Instead of a single function to copy_new_names, you could probably create separate functions to handle each sheet you are adding to. I would also possibly make a duplicate of subscriber and date in between company name and contact email to the getrange in the script …

A Google apps script based on the Onchange trigger will be your friend, free of charge and not so complex :wink:

I do the exact same thing using a script. [image] Email registration reference Ask for Help App:Logins would be the place to get emails. You can use a UNIQUE formula in a new sheet to build a list, but you could run into problems if have other columns in your new sheet t…

Easy said than done for someone who never worked on google apps scripts :slight_smile: Let me see if I can get creative with Arrayformulas and palce-holders - unless there is a ready-made script that I can simply learn how to tweak and plug in. (

My previous attached post includes the script I use. All it needs is a sheet id from your sheet, change the source and destination sheet tabs, and alter the beginning row and column to copy. In my case, my script reflects that the data I want to copy starts on row 3 and I am copying any new unique…

Thanks Jeff - my setup is a bit different, here’s a simplified presentation of what I’m trying to achieve. [image]

Many thanks Jeff - will follow such steps. Much appreciated.

Populating multipls tabs from one tab in google-sheet

Ask for Help

Jeff_Hager June 30, 2020, 12:20pm 3

I do the exact same thing using a script.

Topic		Replies	Views
Copy information from one sheet to another Ask for Help	8	2370	September 27, 2022
Creating one row in one table creates another row in another table Ask for Help	5	796	August 25, 2020
Copy / paste google sheets data from glideapp Ask for Help	10	440	May 15, 2022
Copy Row Script Ask for Help	25	574	August 23, 2021
Create new Google Sheet on Entry Ask for Help	3	308	July 20, 2020

Populating multipls tabs from one tab in google-sheet

Related topics