VBA script

G

Gor_yee

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
 
B

Bob Phillips

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
 
Top