Excel

This query is : Resolved

SAGAR (Querist)
Follow

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)
Follow

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)
Follow

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)
Follow

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Manish Tiwari

rajkumar yadav

THUSHAR MURALI KRISHNA

Abhishek Kabra

ASHOK KUMAR TEKURU

Subscribe Now

Excel

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA