Dynamic formula generation in Excel cells

[ankushrb]

Dear all,

I have following requirements: (please read it COMPLETELY before suggesting a solution)

I want to replicate a formula in a cell to all the rows below it in a way as if it is copied and paste special formula. So all $ and without$ will have relevance while copying e.g.

Example: Initial position:


A B C
1 100
2 10 22 = ($A2+$B2)/$A$1
3 7 66
4 55 88
5


Now formula in cell Cn (n=3 to 5) should automatically get copied if both An and Bn are non-blank.
e.g. formula in cell C3 should automatically get set to ($A3+$B3)/$A$1
e.g 'formula' (and not the value) in cell C5 should be blank

IMPORTANT::::::

I don't want to appear this formula to appear IF AND ONLY IF An and Bn are NON-BLANK. If they are blank then cell Cn MUST be blank (i.e. it should not carry the formula)

The reason why I want to keep is blank is that actual formula I am going to replicate is a so huge that when i copy this formula for 1000 lines, file size becomes more than 10 MB !!!!!


Please help...It is really very critical.....

Regards,
Ankush

[shg]

Please read this COMPLETELY before responding.

1. It would require VBA.

2. There is no way in the world that 1000 copies of that formula would cause a workbook to swell to 10MB.