For Next Loop

i am trying to do something along the lines of

a For Next Loop that selects the cell N6 and inserts the formula
$K$7*F6+$L$7
then fill down to the cell N754
then selects O6 and inserts the formula
$K$8*F6+$L$8
then fill down to cell O754
repeating this until there are no more values in either the K or L column

in the attatched spreadsheet i have deleted the values from 50 something down to 754 but the idea is still the same.

so that each formula inserted keeps the cell from column K and L constant when filled down but F changes, then when the next column is used(ie. from column N to O), the next row in the K and L is used but F starts from F6 and changes as it is filled down again.

any help would be amazing.

I haven't looked at your workbook, but, if you dont want to use Excels Fill Down function manually then you can use this, it will fill down for as much data you have,

Please Login or Register  to view this content.

Hi Kinslayer ,

Here's a simple code that might help you.

Please Login or Register  to view this content.

Another method, by defining the range you can simply insert a formula across the entire range simultaneously

Please Login or Register  to view this content.

ok thanks, that solved all my current little problems.

lol nice references to WOT LordMarcus

Lews.

Lews, if your initial problem has been solved, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

For your next question please start a new thread in the relevant forum, you may post a link to this thread if its relevant.