View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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!