link trial balance to other statements

[houstonfrenchie]

From the trial balance, I have to create 4sheets- BS,IS, Statement of owner
eq. and each statement should be linked to each other and the trial balance
and should update automatically

 

[JLatham]

Use Excel Help, search for phrases like
Create a link to another cell, workbook, or program
or simply
Linking data

Essentially what this will tell you is to start in the cell where you want
information from another cell, worksheet, or workbook to appear and
first type the = symbol
then go to the other cell, worksheet or workbook and select the cell there
and press the [enter] button to establish the link.
Excel will take care of all the work of providing the proper address
reference to the other cell whether it's on the same sheet, another sheet in
the same workbook or another sheet in an entirely different workbook.