Mike,

Check out the worksheet change event.

you should be able to do something with it. You will need to check the cell
in which data has been entered, and then use the row value of that cell to
determine which range of cells to update.

Steve
"Mike R" wrote in message
...

Hi All,

Is it possible to program a macro that will add a user
entered value in cell ("c1") to a range of cells c2-c15.

Then if the user chooses, add another value entered into
("C2"),to a reduced range of cells c3-c15, so each time I
am eliminating the value in the preceeding cell reference.

The spreadsheet, comprised mainly of formula is linked to
a standard chart but it can be adjusted by entering manual
values in the c column, so for the chart to work I have to
keep adding the manual numbers entered to each cell in the
range except the cell in which the manual value was
entered.

Does that make any sense ?, Any help even to part of the
query would be great.

Thanking you in advance

Mike