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