CountIf Macro

[delirium]

I need to add to a current macro which currently copies the master tab and creates a new tab with tomorrow's date on it. For reference here is the current macro:

Please Login or Register  to view this content.

I want to add a bit that opens P:\Call Center Operations\checkin.xls and looks in Column D for the values HRRESL, HRRERN, TVREAS & HRRETA and places the counts in B12, B13, B15 & B18 of tomorrow's tab in the main workbook, respectively.

I think I mainly need help in wording a CountIf statement for the four values. I am fairly certain I can figure the rest out. (but if I can't you'll hear from me)

Thanks ahead of time ... cuz I KNOW ya'll rock!!

[shg]

Maybe like this (completely untested):

Please Login or Register  to view this content.

[delirium]

Am I allowed to say that I love you?

[shg]

Just marking the thread Solved would be sufficient, thanks.