Count and multiply values of multiple names

[stberger]

Hello Everyone,

The following code counts all hours in a row if the name (name1) is matching. The sum will be then multiplied with a factor (cells(6, 14).value).

Please Login or Register  to view this content.

Now I would like to add multiple names to the code for example name1, name2, name3, etc. The last code would then look as followed:

Please Login or Register  to view this content.

What is the easiest way to implement multiple names in this case?

Stefan

[pjwhitfield]

Without seeing the actual data and the current sub in action then it's hard to be certain but I believe the following should do it.

Please Login or Register  to view this content.

[stberger]

Thanks a lot!

I had to move the vertical loop out of the array and then it worked perfectly.

Stefan