I am trying to do something like the following:
Have a Summary WS with companies in the columns with year to date summaries:
Comany 1 Company 2 Company 3...
Balance Sheet
Cash
Receivable
From: Company 1
Company 2
Company 3
PP&E: Equipment
Building
Liabilities & Equity
Ect..
The companies have their own worksheet and have the same formatting for the statements of accounts.
What I am trying to do is be able to add/delete rows in the summary sheet if I need to add accounts and have the summary as a main reference, so that when changes are made to the summary account they will also be made to the individual companies statements.
Bookmarks