I need a script really bad, here is what i need :

In Column D I have week numbers ranging from 532 to 543, and then in
column F, i have sales for an item. In column H, i have a forumla : if
(D=IF(D11=541,AVERAGE(F2:F10), " "), how to i create a script to keep
on looping until the end of the file?PLease help!!!Thanks alot

Looping to do what?

The loop is simple

For i = 1 To Range("D1").End(XlDown).Row

'do something with Cells(i, "D").Value
Next i

--
__________________________________
HTH

Bob

"Gor_yee" wrote in message
...
I need a script really bad, here is what i need :

In Column D I have week numbers ranging from 532 to 543, and then in
column F, i have sales for an item. In column H, i have a forumla : if
(D=IF(D11=541,AVERAGE(F2:F10), " "), how to i create a script to keep
on looping until the end of the file?PLease help!!!Thanks alot