Microsoft Excel - Ledger

Asked By John on 23-Jan-13 10:04 PM
I would like to upload an excel file here, but I could not able to upload. Uploading menu not showing anything
Robbe Morris replied to John on 23-Jan-13 10:19 PM
For security reasons, you'll have to .zip the file up.
John replied to Robbe Morris on 24-Jan-13 08:40 AM
Accounts Statement.zip

Sir, I have attached file, I would like to make an account statement as given on New Format sheet. There is showing some errors in that format. Sheet not displayed all names. Can you solve this problem?

 
Donald Ross replied to John on 24-Jan-13 01:24 PM
John,

on your sheet opening balance you have
Aanand & Company
listed twice with two different amounts, and on your data sheet your dont.
so one has 13 and one has 12 enrtys.   as for the math it all looks like it works fine, what exactly is it doing wrong.
or what do you want it to do different.

Don
Harry Boughen replied to Donald Ross on 24-Jan-13 02:59 PM
Hello Donald,
I think it is the macros that need fixing.
Harry
John replied to Donald Ross on 24-Jan-13 09:59 PM
Sir, I need macro to run this ledger. Avoid Opening Balance Sheet. That I just do for test,