Autofill cells after entry in one cell via VBA 1

[shelby55]

Hello

I am using Excel 2010. I have data in a worksheet (M1B) where all the columns are dynamic named ranges. Column A has dates and Column B has a value which I'm entering in manually. Columns C is the same for all timeframes, D is average of the range (calculated citing the named range), E is the "moving average" to aid in calculating upper and lower control limit values, F is the UCL calculation and G is the LCL calculation.

What I would like to have happen is that when the next row in A and B have data in them I would like the other columns to update automatically. I assume I'll be using the Worksheet_SelectionChange event but that's all I know.

All assistance is greatly appreciated, thanks.

 

[SkipVought]

If your table were a Structured Table, the formulas would propagate to the new row when you add a new row to the table. Simply make it a Structured Table!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi Skip

Thank You! Not sure why I keep forgetting about structured tables because they really are amazing and that fixed my problem.

Thanks again!

 

[SkipVought]

Sometimes it's difficult to break old habits and begin new ones! ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}