Populating a Summary ReportClosed

Question

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

Zohaib R · Answer

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.

ExcelNewb17 · Answer

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

Populating a Summary Report

2 responses

Similar discussions

Subscribe To Our Newsletter!