Need a formula/VBA code .

chintu

New Member
Joined
Apr 1, 2018
Messages
17
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.
 
Last edited:

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
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
 
Upvote 0
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
 
Upvote 0
chintu,

No more Private Messages.

What you asked is NOT PERMITTED on the MrExcel Site.
 
Upvote 0
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......
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top