Automation: Copy cell value to another sheet
Hi, not sure whether this has been answered yet but my question is as follows:
I have a sheet, Sheet A, that stores all the projects and their information, such as Project ID, project status.
I have another sheet, Sheet B, that stores only projects that have reached a certain stage (ex. in execution).
And I just want to know if it is possible to automate copying JUST the Project ID from Sheet A over to Sheet B when it has reached the execution stage. I have tried formulas and automation but automation can only copy the entire row, when I only need the Project IDs. Also, both Sheet A and Sheet B have a different structure, hence copying the entire row would not work for me.
Would appreciate any help or suggestion with this, thanks!
Help Article Resources
Check out the Formula Handbook template!