How to copy the cell values from diffrent workspace sheet into single sheet (Automate the process)
Hi Team, quick help needed.
for example i have 10 project (each is a workspace), each project have 1 sheet with multiple columns and i need to fetch information of 4 columns from this sheet AND then put it on the separate sheet (can call it as master sheet) has information on project level i.e each row is a project in this sheet which would be coming from each workspace sheet.
Note: each workspace/project sheet and the master sheet do have a column like primary/unique identification which can be used.
ONLY THING TO KEEP IN MIND IS WE WANT TO AUTOMATE THE PROCESS AND NOT MANUALLY FEED THE INFORMATION INTO IT. AS THE NUMBER OF ROWS WILL GROW ON MASTER SHEET AS ITS CONNECTED TO SALESFORCE.
Attaching the sample screenshot for better clarity.
1st sheet is from the each project/workspace. last 4 columns data i am trying to copy. have a GPS number as unique which will be available on the matersheet as well
2nd sheet is a mastersheet where i am inteded to move the data into.
PLEASE HELP !
Help Article Resources
Check out the Formula Handbook template!