I am trying to do something like the following:
Have a Summary WS with companies in the columns:
Balance Sheet Comany 1 Company 2 Company 3...
Cash
Receivable
From Company 1
Company 2
Company 3
PP&E
Liabilities & Equity
Ect..
The companies have their own worksheet and have the same formatting for accounts, IE the same as above.
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