VBA script

  • Thread starter Thread starter Gor_yee
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct by date 4
Sum every Nth Row (almost working) 1
Excel VBA 1
Excel Excel VBA Script help 0
Mandatory cells only if another cell is filled 0
enter value if 2 criteria are met 5
Computationbs on Duplicate Entries 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top