do the same thing to multiple hard coded cells
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
|