Push or pull a new cell value to other sheets

Janet Skjerven

When a new project is created, a unique project ID is entered into a master project table/sheet. When that project ID is entered, I want to be able to automatically populate the project ID cell in two other sheets. Any direction and/or creative ideas are appreciated.

Regards,

Janet

daisyq

Use your automation functions. Fairly standard and intuitive to set up.

Janet Skjerven

Hi Daisyq,

Thanks for responding. For automations to work for me, I would need the functionality to change a cell in another sheet. You can only change a cell in the sheet where automation is created.

I could use the automation to copy a row to another sheet, but in this case the sheet columns vary significantly so that won't work for me.

Andrée Starå

Hi @Janet Skjerven

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet, and then copy/move the row from that sheet to the main destination sheet.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Janet Skjerven

Andree, thanks for the input. Will test it out tomorrow and let you know.

Andrée Starå

@Janet Skjerven

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Janet Skjerven

I was able to get your suggested solution working today. Success!

I created two helper sheets, then to pull the project ID from the master table I used Index/Collect, then created the automations to move the rows to their corresponding production sheets. Once moved, cleared the cells through the automation.

Thanks again.

Andrée Starå

@Janet Skjerven

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!