I believe I'll call this one finished. I have to do some data validation but I don't believe there will be any additional "structural" changes/additions. I would guess that this took about 24 to 30 hours to complete but it was worth the effort. I've learned several things related to extracting data from the Sales Analysis files (SAPMSSM, SAPMSSY and SATHITB). I was surprised to find that, when completed, the workbook contains 8 queries and 97 named ranges.
In future posts we'll take a detail look at some of the elements that make up this workbook. One of the first will be using radio buttons to display different charts. Then maybe using the "Camera" to display the "Inv Summary". How to include the year in a header so it automatically changes when the year changes.
If you have any questions about this workbook you can leave a comment here or email me at the office and I'll respond to you as soon as possible.
No comments:
Post a Comment