Data Shuttle : adding several rows in target sheet from one row in source sheet.

Cynthia Guay

Hello,

I need to built a commission sheet for all the sales made into different contracts and several sales can be made in 1 contrat.

-I have my master sheet with all the contract on separate row.

-Sales type are located in the master sheet in different column name.

-I did different data shuttle for each kind of sales ( offload and upload) .

My problem is that if i'm selling 2 things of the same contract i got only 1 row in my commission sheet showing up and the information overwrite the other one. i really need to keep 1 row for every sales type.

How can i do that ? i'm missing something.

thanks a lot.

Have a wonderful day :)

Andrée Starå

Hi @Cynthia Guay

I hope you're well and safe!

I've developed some client solutions without using Data Shuttle and a form or input in a sheet instead.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cynthia Guay

Hello Andrée,

No sorry, we don't have more money to spent to get this work. So no it's not working. BUT Thanks for trying to help me :)

have a good one