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
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
Regards
Related:
- Populating a Summary Report
- Crystal report viewer download - Download - Data management
- Summary slide powerpoint - Guide
- Report a login issue - Facebook Messenger Forum
- How to get 1st appeal for report a login issue - Facebook Forum
- Report an impostor account - Facebook Forum
2 responses
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
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.
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
Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017
Apr 27, 2017 at 11:49 AM
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
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
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
Apr 27, 2017 at 12:28 PM
Thank you,
I have received Example1 file. I am working on it.
I have received Example1 file. I am working on it.
ExcelNewb17
Posts
3
Registration date
Wednesday April 26, 2017
Status
Member
Last seen
April 27, 2017
Apr 27, 2017 at 12:58 PM
Apr 27, 2017 at 12:58 PM
Thank you!