Populating a Summary Report

[Closed]
Report
Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017
-
Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017
-
I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The task is to sum/reconcile based on the cost centers associated with the debit/credit. Besides creating 75 or so formulas, is their an easier way?

Regards

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi ExcelNewb17,

You can always simplify reports. However, the short description that you have provided is not sufficient. Your excel file seems to have sensitive/confidential data. If you can have a mock-report created with some data which is not sensitive/confidential and also upload it to: TinyUpload, I can try to help you with your report.

Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017

Zohaib,
Here is a sample of what I am looking at. I have left off a lot of the extraneous descriptions in the other fields as these are the ones I am most interested in. Basically, the fund number denotes which fund it corresponds with and the account number determines the category it goes in. Not the greatest example, but my hands are a little tied as to what data I can show. Thanks for any assist you can give me.

The file is: http://s000.tinyupload.com/?file_id=24480763304784037494
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Thank you,

I have received Example1 file. I am working on it.
Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017

Thank you!