Populating a Summary Report

Closed
ExcelNewb17 Posts 3 Registration date Wednesday April 26, 2017 Status Member Last seen April 27, 2017 - Apr 26, 2017 at 12:20 PM
ExcelNewb17 Posts 3 Registration date Wednesday April 26, 2017 Status Member Last seen April 27, 2017 - Apr 27, 2017 at 12:58 PM
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

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 26, 2017 at 12:32 PM
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.

0
ExcelNewb17 Posts 3 Registration date Wednesday April 26, 2017 Status Member Last seen April 27, 2017
Apr 27, 2017 at 11:49 AM
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
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 27, 2017 at 12:28 PM
Thank you,

I have received Example1 file. I am working on it.
0
ExcelNewb17 Posts 3 Registration date Wednesday April 26, 2017 Status Member Last seen April 27, 2017
Apr 27, 2017 at 12:58 PM
Thank you!
0