Duplicate row's

Aditya Tongar

Hello, I have consolidated 17 files into one and have created a workflow which ensures that every time a new row is added on these sheets, it will be copied on to the consolidated sheet as well. 

But the downside is that every time a row data is updated on these 17 sheets, it creates a duplicate row in the consolidated sheet, instead of updating the original row data.

Is there a way I can just get the rows updated instead of creating a new one?

Paul Newcome

Have you looked into Reports?