How to add Project Manager& Project ID from another sheet to a blank sheet?

yj92

I have been having issues with the limited cell reference so I thought I would create a helper sheet.

Since my helper sheet is blank, I wanted to add project IDs and project managers that appear on my main sheet to my helper sheet. I don't want to manually input the project managers and project id into my helper sheet

Helper Sheet.PNG

Main sheet.PNG

Has anyone figured out how to do that?

prime_nathaniel

@yj92 the most scalable core feature to do this is data mesh. The most scalable solution overall is custom API with bridge.

Use project ID as your key, if key does not exists add + copy.