ActiveCell.Formula = "=IF(COUNTIF([item.xls]item!B:B,
G7),VLOOKUP(G7,[item]item!B:L,11,0))

In the above formula the the G7 value shoulbe changed with G and active row
number

example

if current active row =3 then G7 should be changed into G3
if current active row =8 then G7 should be changed into G8

Please help ro rewrite the formula

Pol