Entering changing formulas in every other cell

**pangro** · 03-27-2013, 12:37 PM

Hello
My first post and i also have to say i am a beginner at writing macros.

I have a problem and i would ask for advice. I would like to write a macro for excel that enters formulas as follows. First i would like to divide cells with each other in this order C3/D3, C3/E3,C3/F3, C3/G3 etc. if there is no value in next cell it goes to divide D3/E3, D3/F3, D3/G3 etc if there is no value in the next cell it goes to divide E3/F3, E3/G3 and so forth until no value is left to divide.
Each division or formula is entered in the target cells in this sequence: T3, AN3, BH3 etc. So first target cell is T3 and next one is always every 20th cell. So first formula which divides C3/D3 is entered in T3, second C3/E3 is entered in AN3 and so forth.

For now i have 16 cells filled with values from C3 to R3 and i had to write 120 sentences in vba to solve this but problem becomes huge when i will be adding another cells filled with value.

tnx