Best way to automatically copy and update rows from multiple sheets to master sheet

Ahmet - newby

Hi all,

I have 10 sheets owned by different people who enter rows of information. Each row on each sheet has a unique code.

I'm trying to do the below actions:

1. Copy the rows from the 10 sheets automatically to a master sheet.
2. Order them by the unique row code
3. Enable each owner to update any cell in any row of their own sheet, which will then automatically update the corresponding row in the master sheet (I don't want a second "same" row to be copied to the master sheet). Every cell in the row can be changed except the unique row code (as a reference point).

Can anyone help me establish the right workflow and formula to enable the above 3 actions?

Thanks,

Ahmet

Ahmet - newby

Hi Andree,

For now I'm just extracting from a report.

Works for what I need for the time being.

Thanks for coming back to me.

Best regards,

Ahmet

Paul Newcome

Have you looked into pulling a report that references all 10 of those sheets?

Ahmet - newby

Hi Paul,

I forgot to add - I have another workspace with sheets that need to take the unique row code as a reference and I don't think you can copy a cell from a report into a sheet - is that possible?

Thanks...

Andrée Starå

Hi @Ahmet - newby

I hope you're well and safe!

To add to Paul's excellent advice/answer.

• What is the Unique row code? Is it a running series?
• Do you have access to the Premium App, Data Shuttle?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ahmet - newby

Hi Andrée Starå,

The unique row code relates to a specific customer, so it will not change and I want to use it across multiple workspaces. The code is automatically generated when the customer information is created in the row. It's like a database but we don't create the code manually. It is a running series but each row code is different on each of the 10 sheets. I'm afraid I don't have the Data Shuttle app.

Sorry if it sounds a little complicated and thanks for the help.

Best,

Ahmet

Andrée Starå

Hi @Ahmet - newby

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

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

Ahmet - newby

Hi Andree,

For now I'm just extracting from a report.

Works for what I need for the time being.

Thanks for coming back to me.

Best regards,

Ahmet

Andrée Starå

@Ahmet - newby

Excellent!

Happy to help!

Glad you got it working!

sonek

If you use unique identifiers on all the individual forms and the master form you can do a vlook up to the master form.

Ahmet - newby

Appreciate that Seda - I'll check it out to see if it helps to find a better solution than the one I have right now.

Thanks...