Excel pivot or Power Pivot RRS feed

  • Question

  • I have a trial balance with "acc no", "acc name", "link no", "link name", "opening balance", adjustments", "closing balance Current year" and "closing balance prior year 1" column's. I want to create lead schedules using pivot or power pivot ie sheet1 with TB and the following sheets displaying the lead sheets ("link name") and then on the lead sheet group by "acc no" or "link no".

    Links being the classification as Income, expense, current assets, current liabilities etc.

    Thank you very much in advance for your response

    Friday, September 12, 2014 3:34 PM


All replies