+ Reply to Thread
Results 1 to 2 of 2

Excel forms

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Excel forms

    I have a summary of accounts worksheet with balance sheet, income statement, cash flow statement. The list of accounts under each finance statement is the same for each company that has their own work sheet. The summary work sheet is a roll-up of all the companies. I am trying to make it so if I need to add a row or change something in the summary of accounts worksheet, the same actions will be applied to the individial companies work sheets that share the same accounting format. I am basically trying to avoid having to add or delete a row for each company if I need to add or delete a line in the finance statements in the summary. Any help is greatly appreciated.

  2. #2
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Excel forms

    Another way of explaining is I want all financial statements throughout my model to mimick or copy the summary financial statement. If I add a line or new account to the summary, it does the same to all other financial statements that are referencing or copying the summary statement.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1