Automatically copy data from another sheet with different columns names?
Hello, thank you for reviewing,
Hoping to copy data that is added on 1 sheet (from an intake form) to another sheet automatically with column names that are different in both sheets. I cannot data mesh as I don't have the primary information yet to match columns up. Every new project automatically gets a new project ID after its entered in sheet A
Hope that makes sense? Thank you