Hello!

How can I repeat a function to multiple cells that are hard-coded with data?
For example, I have the following data hard-coded:

D ..... H
1 50 42
2 38 37

What I would like to do, is add what is in D1 to what is already hard-coded
in H1 (in this case, 42 + 50, but I don't want to go back into every cell in
column H and type in the "+D1"), and add D2 to what is in H2, etc.

Any help is appreciated! Thanks!

Select the cells in column D and copy them. Click on H1 and:
Edit PasteSpecial Add
--
Gary''s Student - gsnu200772

That works great for this particular application, but just for future-use
probability, is there a way to do it without losing the cell reference? To
keep it as "=42 + D1" for example? Thanks!

"Gary''s Student" wrote:

Select the cells in column D and copy them. Click on H1 and:
Edit PasteSpecial Add
--
Gary''s Student - gsnu200772

In a helper column enter =D1+H1

Copy down as far as you have data.

The cell refs will increment.


Gord Dibben MS Excel MVP


On Fri, 7 Mar 2008 07:42:00 -0800, Sam wrote:

That works great for this particular application, but just for future-use
probability, is there a way to do it without losing the cell reference? To
keep it as "=42 + D1" for example? Thanks!

"Gary''s Student" wrote:

Select the cells in column D and copy them. Click on H1 and:
Edit PasteSpecial Add
--
Gary''s Student - gsnu200772