Hi,
I have a set of data under different analyst names in Sheet2 and Sheet3.
Something like below:
John Lucy
pass fail
fail pass
pass error
error error
pass pass
fail pass
I would like to have a macro that summarizes data under John and Lucy (found in Sheets 2 and 3) and gives the totals in Sheet1.
So for example in Sheet1 we will have totals:
John
pass 3
fail 2
error 1
Lucy
pass 3
fail 1
error 2
The analyst names are found in Row 9 of Sheets 2 and 3 (let's say a range K9 to O9)
The data to be summarized will be under those names (let's say in range K29:O50)
How can I summarize in Sheet1 how many pass, fails, errors are under John and how many under Lucy if the analyst names are found in range K9 to O9 of Sheet2 and Sheet3 and the data to add up is found under the analysts names in range K29:O50 of Sheet2 and Sheet3?
I would like to have macro and not use a Pivot.
Thanks,
N.
I have a set of data under different analyst names in Sheet2 and Sheet3.
Something like below:
John Lucy
pass fail
fail pass
pass error
error error
pass pass
fail pass
I would like to have a macro that summarizes data under John and Lucy (found in Sheets 2 and 3) and gives the totals in Sheet1.
So for example in Sheet1 we will have totals:
John
pass 3
fail 2
error 1
Lucy
pass 3
fail 1
error 2
The analyst names are found in Row 9 of Sheets 2 and 3 (let's say a range K9 to O9)
The data to be summarized will be under those names (let's say in range K29:O50)
How can I summarize in Sheet1 how many pass, fails, errors are under John and how many under Lucy if the analyst names are found in range K9 to O9 of Sheet2 and Sheet3 and the data to add up is found under the analysts names in range K29:O50 of Sheet2 and Sheet3?
I would like to have macro and not use a Pivot.
Thanks,
N.