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.
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!!
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.
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.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- ITR-Capital Gain
- CLOSING STOCK QUERY
- Gst on travel by air for business purposes
- GST ISD Query on various AMCs
- IT returns for fresh job holders
- F&O reporting in ITR
- Query regarding TDS on EPFO Higher Pension Arrears- under wrong section
- TDS on rent received on hardship compensation being rent on redevelopment of building
- Sale of Mutual Funds In Diffirent Financial Years
- CASH GIFT FROM BLOOD RELATIVE
- Itr processing refund
- U/S 194 T
- TDS refund Indemnity Bond
- ITC BENEFIT ON BROKRAGE PAID
- PF wage ceiling
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
