Dec 05 2021 10:35 PM
Hello Everyone,
I've came here looking for help to solve an issue I'm facing..
I have multiple sheets and I want to copy different cells and paste them in a summary sheet.
How can copy " total operation revenue " from each factory sheet to the summary sheet, and same goes " other operation" , operation expenses and so on, without me going back and forth between those sheets.
Please find the attached file for a clean picture of my issue
Thanks, Sami
Dec 06 2021 12:24 AM
@Sami86 Look into using the INDIRECT function as demonstrated in the attached file. I suspect, though, that your real life situation may more complex than your example sheet. And then there are probably better ways to summarize the data. But for now, I'm just answering you question.