I am an ordinary accountant but not familiar with macro & VBA. I have a file, I need to copy a source formula to a certain range of which starting position has fixed already and ending position would be altered regarding to condition changed.
For example, say
source formula : locating at cell G11
conditions : range of row containing data in column F starting from F11

Says now, there are 10 data starting from F11 to F20, therefore I need to copy the source formula from G11 to G20.

Same as, when there are 100 data starting from F11 to F110, I need to copy the source formula from G11 to G110.

Can someone advise me how to specify the range in performing a macro in Excel v2002. Thank you very much.

Eric C