How to transfer data from one sheet to another and then have it place in the correct place
I am trying to take data that is input in a form and managed in one sheet and automatically copy it to another sheet linked and input in a certain section based location criteria.
Here is currently what I am doing:
Sheet form data goes into that I want to use to manage a dashboard
Sheet that I want to automatically pull data into, and input into a certain area based on a common item (Weld002 for example)
Is possible to automate this?
Help Article Resources
Check out the Formula Handbook template!