PDA

View Full Version : summing range of row



sal21
01-04-2008, 02:09 PM
sorry but i think this question go here...
http://www.vbaexpress.com/forum/showthread.php?p=128268#post128268

Bob Phillips
01-04-2008, 02:24 PM
Answered there.

stanleydgrom
01-04-2008, 03:06 PM
sal21,

Here you go - see the attached workbook "Cartel1 - sal21 - 20080104.xls".

I added a Worksheet_Change Event that will monitor column A. Each time you add an entry in column A, field title "UFF. AG.", the formulas in column N will be updated, and the formula in cell N3 will be updated dynamically.

Have a great day,
Stan