Journal Ledger Balance

Dear All,

Ref attached sheet

I m facing a big and urgent problem in my worksheet..i have done my all work here but now i knew that there is a difference in this vb code..

I need your urgent favour to rectify it for me..

What i need is sheet1 is my journal jounal (data) and sheet2 is my reporting place where i set a macro button at top to update the report..

But in sheet2 column I i need an auto Balance of debit & credit..

Pls have a look on my sheet and do some thing..

Thanks in advance

General Ledger.xls

I don't see any code on your workbook provided.

Please place the code your are talking about and reattached. And I understand correctly, your individual GLs are not showing the correct GL balance as of a given date, right?

Well, if your code is influencing the output of this column, we definitely need to see your vb code. But if not, then you just need a formula on J6=J5+G6-H6..

Please advice further..

Ron

EDIT: Just a very quick free accounting lesson, the first sheet will be called the General Journal, and the other sheets are General Ledgers ... :D

thanks for quick response..

sorry i forgot to attach my code..here is my code..pls insert it in my sheet already attached and than try for me as i need it urgently cuz my all work is going waste..thanks

Code is attached down in next post..thanks

Please change the PHP tags to CODE tags.

Thanks.

No one is working on it because the macro you posted was for a completely different sheet layout. It actually doesn't work at all for this project, which I'm sure you know by now.

So in case you don't realize it, but you're asking someone to first figure out what the old macro was supposed to do based on a sheet not seen here...then rewrite the whole macro to match your new layout...THEN finally get to your new issue.

You re-attached the very same workbook you posted in your first post.

Sheet1 is only data, this macro was recorded by you to make an auto report in sheet2, which is good but only problem is highlighed in sheet3.

What JB tried to say is to post the workbook that will work with the code provided. That code cannot work with the sheets provided, so both items that you posted are useless. Post your actual workbook that has Sheet1 (Your data as you call it), and the gurus here will run your code and make recommendations. Do not underestimate the power of providing as much details as possible. You may think that they don't need it, but they are the experts. So if you want a response, I will suggest that you provide them with what they need.

And by the way, there is no Sheet3 on your latest attachment where you say you were going to highlight something...