Hi,
I'm trying to create a workbook where we would update each sheet, and that should automatically update the central sheet.
If it's easier, then we could insert the data into the central spreadsheet, and it should automatically update the other sheets, according to the sheet name in a table on the central sheet.
We have expenses and income for each unit on separate tabs, I want to combine these into one.
This is a unit tab:
and this is what I want the central tab to look like:
thank you very much, I hope this is clear.
I'm trying to create a workbook where we would update each sheet, and that should automatically update the central sheet.
If it's easier, then we could insert the data into the central spreadsheet, and it should automatically update the other sheets, according to the sheet name in a table on the central sheet.
We have expenses and income for each unit on separate tabs, I want to combine these into one.
This is a unit tab:
and this is what I want the central tab to look like:
thank you very much, I hope this is clear.