Creating an exception report through EXCEL macro
Posted by Glenn Welldon on November 14, 2001 4:42 AM
As I only just begun work on this project, I am a bit stumped on how to create an execption report through Excel VBA based on an excel file called Project Billing System text.xls, it must automatically generate exception reports for those:
Billed, paid correctly
Billed, Not Paid
Billed, Paid, low
Billed, Paid, High
Not billed, not paid.
Much appreciated if you can give a hint on what resources or tips etc, thanks.
Glenn:)
Posted by Joe Was on November 14, 2001 6:18 AM
Your billing is all standard - simple value tests, so we will move on to the design.
Create new named sheets for each exception type. Then test your data for each condition regarding billing. Pass the correct billing type to the correct sheet using "xlUp" which adds your selected ROW data to the bottom of a list of that type of billing on the correct sheet name. Test for the last ROW of data checked on your data sheet, then run or call new code to operate on the selected data in the individual billing sheets. I use text and value functions to list descriptive information about the data examined. Like: "This cycle 48 new clients were added to the billing system."
I attach "Form Buttons" to a navigation sheet or to the top of the data sheet, which run the macro code. This makes your project user friendly and have the appearance of a software application. JSW
