help with Applying nested Loops

V

vicky

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
 

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

Nested If / And Statement with Conditional Formatting. 2
VLookup: Return Multiple Columns? 6
Please help with simple function 1
RANGE & NESTED LOOPS 1
Error Handling with Nested Loops 3
Nested IF with a possible SUM? 1
Need help with nested funciton using vlookup 6
Help requested for nested conditional formulas referencing other c 3

Top