Unique Count Values by Advanced Filtering based upon UForm CBox Selection

Hello,

I’m working in Excel 2007 and I’m having a problem with advanced filter, copy and count unique records. The attached file has a table report (“ExpComInvc”), userform (to set up invoice), table (“ExpData”) and temp tbl (“CIDataFltrd”) where unique values (from Col S of ExpData tbl) are copied (macro CIPkgListUnique) in order to populate a combobox (Col A of CIDataFltrd tbl) upon initialization of userform, which appears to work fine although the code for clearing Col A before the advanced filter runs may need to be optimized. An advanced filter macro then is supposed to copy the filtered values (from Col D of ExpData tbl) to the CIDataFltrd tbl (col B) based upon the value selected from the combobox (macro CIBoxFilter). A VBA function (macro CICntBoxes ) then counts the values in the temp table (Col B of CIDataFltrd tble) to get the unique records count which is the number of boxes. The unique value count (# of boxes) appears on the userform (at this time for test purposes) and then is written to a field in the table report. The issue is that the advanced filter copies more values than it should (for example it should copy 3 values but also includes values that are outside of the value chosen from the combobox) therefore the unique record count is off.

Another issue is that I am trying to total weights (macros CI***WgtSum***) based upon the combobox selection and grade (cols B and G of ExpData tbl).

I’m trying to execute the above by clicking the review invoice button on the invoice which may or may not be possible or the best way to approach the desired functionality.

I’ve spent considerable time trying to resolve these two similar issues without success. I would really appreciate any help in solving this issue.
Thanks much!