Excel

Save Share

This query is : Resolved

SAGAR (Querist)

21 February 2013 Dear friends,
I have a Balance sheet. as per requirment of the client i used to makes changes in the other schedules. each time i make a changes i want to know the difference in total assets and liability.
again i want it should be reflected in each sheet of the work book.
Please help me in this.

@VaibhavJ

@VaibhavJ (Expert)

21 February 2013 Hi

Use excel watch window..

In formula tab there is watch window..

Here you have to specify the cells on whom watch is to be kept.

Thanks!!

CA Prashant Gupta

CA Prashant Gupta (Expert)

21 February 2013 you can simply link your balance sheet with schedule in excel
everytime you will change schedule, in balance sheet and P/L change will take palace automaticlly
for difference in Asset and Liab. you can simply use Asset-Liab. formula.
don't use advance formula, if you don't know
simple formulas are best.

SAGAR

SAGAR (Querist)

21 February 2013 Thank you sir, thanks u so much

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now