Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with Applying nested Loops
i have small query with the looping thing . i have data something like
this . i need to write a nested loops to apply Formula and autofil methods in these specific cells . can you please help me out in writing the code . I have Products and Year in two different rng variable (RngProducts,RngYear). need vba code lo loop thru the cells and apply formula . if i apply the formula then in the next column i need to autofill method A B C D E F G Products Year1 Year2 Year3 Year4 Year5 Year6 1 frmla autofilll---------------------------------------- 2 0 frmla1 Autofilll---------------------------- 3 0 0 Frmla3 Autofilll----------------- 4 0 0 0 frmla4 autofilll-------- Frmla , Frmla1 , Frmla2 , are different formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Do While Loops | Excel Programming | |||
Help with nested for loops | Excel Discussion (Misc queries) | |||
Help with nested for loops | Excel Worksheet Functions | |||
Help with nested for loops | Excel Programming | |||
nested for loops and end for | Excel Programming |