I am trying to produce financial statements, i.e. Balance Sheet, Income Statement, etc. based on Raw Data from my Trial Balance.
I've attached a sample of the "raw" data but I'm not sure what type of formula to use to populate the "Balance Sheet" based on the numbers for a particular month and account.
I hope that makes sense.
Any help would be so very much appreciated.
Last edited by FDibbins; 07-27-2013 at 07:36 PM. Reason: Removed File, sentive data?
Hi and welcome to the forum
I removed your file, because when I looked at it, it looked like it contained sensitive/confidential info. If this is not the case, my apologies - you can upload again (I am working on what you want though)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I see that you have categories in H that do not seem to exist in E? Could you give a few sample answers so I can see what you are doing?
Thank you for your reply, the reason there are some items in H that are not in E was only because I was just starting to try to figure out where to begin and I only populated through H25 - Total Current Assets.
By the way, thank you for removing my file you were correct that it had sensitive data (which I thought I removed).
I closed your file yesterday and did not save a copy, so is there a possibility that you could put a dummy file together for me?
Here you go, thank you!
Help File 07-28.xlsSorry I forgot the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks