Select which columns to copy or move from one sheet to another

jgleason

We use Move and Copy Row automation in many of our processes. One 'unfortunate' component of a Copy\Move action is that the ENTIRE ROW-all columns of data- must be handled in one package. Wouldn't it be great, if I could tell the automation specific columns to move forward?

Example: Copy\Move entire row out of sheet one, but only populate specified fields in sheet 2.

This would allow me to set conditions to "Pass Data Along", but not have to send all the data related to Process #1 into Process #2. Our example is a Universal Schedule, that, once a condition is met can pass along core data to several downstream schedules based on project status point being reached.

Rich Coles

Hi @jgleason - I achieve this using Data Shuttle, although I appreciate this maybe not a helpful answer if you don't have Data Shuttle, but maybe give it a trial… I've done a video demonstrating it in action https://youtu.be/sf7zLNQRGI8