Adding Cell Values to Ranges

  • Thread starter Thread starter Mike R
  • Start date Start date
M

Mike R

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
 
Thanks Bernie, I'll give that a go, it has put me in the
right direction !

-----Original Message-----
Mike,

I think if your use the formula

=C1

in cell C2 and copy it down to C3:C15, you'll get the
Click to expand...
result you want. You don't say what the value in C1
should start as, so you
should consider that aspect of the problem.

If you want a macro to enter the user's value for him,
Click to expand...
you could use this line to enter user entered numbers into
successive cells
 
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
 
Back
Top