Easy Office
LCI Learning

Excel

This query is : Resolved 

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.

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!!

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.


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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query