do the same thing to multiple hard coded cells
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! |
do the same thing to multiple hard coded cells
Select the cells in column D and copy them. Click on H1 and:
Edit PasteSpecial Add -- Gary''s Student - gsnu200772 |
do the same thing to multiple hard coded cells
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 |
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 |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com