I would appreciate some help with this project. Using VBA: for each row in the below table, I would like to create a variable of the sum of certain columns based on the value in row 3. For example: activity code HC9200006, if the column header in row 3 is a '2', i want to sum those values together (so the result for this code would be 35). Then I would like to do the same thing for when row 3 is a '3'.
The end goal is to compare those sum values against the 'CLASS' field for each activity code, and then highlight the row if certain conditions are not met. Thanks in advance...
_
The end goal is to compare those sum values against the 'CLASS' field for each activity code, and then highlight the row if certain conditions are not met. Thanks in advance...
Code:
_ 'row 3 1 2 2 3 3
ActivityCode CLASS VL200 VL300 LAB MEDSRG
HC2702842 0 0 0 0 0
HC2702820 0 0 0 0 0
HC9200006 1 30 5 0 0
HC4800266 1 0 0 0 0
HC2600005 1 10 30 0 0
HC2701584 2 0 0 1 16
HC2702780 2 0 0 0 139
HC2702782 2 0 0 0 118
HC2701766 2 0 0 1 24
HC2702818 2 0 0 0 29
HC2700933 2 0 0 1 21
HC2702781 2 0 0 0 291
HC7600084 3 7 15 0 1