2007 - How to transfer a value from another worksheet with a condition

[kamelkid2]

Please Login or Register  to view this content.

i know the problem is that the code fails when trying to 'look' into worksheet 'Batters!'

if i change the line from

.Formula = "=IF($AB2=1,Batters!KS2,"")"

to

.Formula = "=1+1"

the expression works properly.

essentially what i am trying to do is transfer the value of worksheet 'batters ks2' to worksheet 'hitterscalc d2' if the value in cell 'hitterscalc ab2' = 1, and do this for all the rows that have value

[kamelkid2]

solved myself - i needed 4 quotations in the expression

[kcarley]

Which is more important; the VBA to do it or the result in column D?