Applying formula to dynamic range.

[willist]

Greetings.

I have two dynamic ranges, Columns A and B. I want add to my macro so that column C is automatically populated with

=IF(A3-A2>1000,A3-A2+B2,B2)

for C3,

=IF(A4-A3>1000,A4-A3+B3,B3)

for C4, and so on and so forth for the entire range of A and B. That is, if A and B expand and contract, C should match. I have been able to define the dynamic ranges by using the Name editor, but I do not know how to apply a specific cell-by-cell formula to the new range.

Any help would be appreciated.

Thanks

[Pepe Le Mokko]

You have XL2010 ? Then use the Table feature - Named ranges will not be necessary

First select the range formed by col A and B - Select the Insert Ribbon - Click "Table" and follow the instructions
Next, in col C add a header if needed - in the cell next to 1st row of data col A and B, enter your formula, it will expand automatically to the last value of col B
Now when you add or delete values to or from col B, the formula in col C will follow without you having to do anything

[Cutter]

Hello willist, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.