my file: http://www.mytempdir.com/941009

with a macro...

in GAF sheet column H with data.
In sheet Corporate, Retail_Poe ecc... have a column G with other data.

I want count how many value are present in column H of GAF refered column G
of CORPORATE and store in a variable named CORPORATE...

I want count how many value are present in column H of GAF refered column G
of RETAIL_POE and store in a variable named RETAIL_POE...

ecc...

The rest of value in GAF not finded store in a vaiable OTHER....

tks.