 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008do 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! Select the cells in column D and copy them. Click on H1 and: Edit > PasteSpecial > Add  SignatureGary''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! > Select the cells in column D and copy them. Click on H1 and: > Edit > PasteSpecial > Add 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 >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! > >> Select the cells in column D and copy them. Click on H1 and: >> Edit > PasteSpecial > Add |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.