Need a formula/VBA code .

[chintu]

Hi team.
I have 3 sheets.sheet1(summary).sheet2(TB) and sheet3(balance sheet). In sheet3 I have one account called 2930-retain earnings current.the total balance of 2390 should be matched with TB ledger account 3000 to 9999 balance.

The results I want in sheet1 .. give me some formula to get the both balance in sheet1.. like 2390 balance=1000.00 and TB Balance from 3000 to 9999 total balance =1000.00 so both are knock off.

I give me some formula Either excel formula or VBA code .

Let me know if you want some additional information.

 

[Caleeco]

Hello Unfortunately you haven't provided enough information for anyone to help you.

How do we know which columns the balance totals in? What to 3000 to 9999 balance mean? where in sheet 1 do the results go? what is the output (True False). Posting a screenshot of your sheet would help.

Cheers
Caleeco

 

[hiker95]

chintu,

It would help if we could see your actual raw data workbook/worksheets, and, what the results (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[hiker95]

chintu,

No more Private Messages.

What you asked is NOT PERMITTED on the MrExcel Site.

 

[chintu]

Sorry, thanks for your confirmations

 

[panyagak]

Hi.

Am an accounrant and to get you RIGHT:

Are TB ledger account 3000 to 9999 Profit & Loss ledger accounts?

What is the actual report name of Sheet1, as known in Accounting?

Are the 2 other sheets CROSS-REFERENCED to sheet2(TB - Trial Balance)?

Other than Profit or Loss normally transferred to Retained Earnings account, are there other components in the R.E. A/c.

Unless this critical information is available, an Excel solution may not be forthcoming......