View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wayne Wells Wayne Wells is offline
external usenet poster
 
Posts: 7
Default Inserting a fixed value in to hundereds of cells

I have 3 years worth of daily data in a spreadsheet. To "normalize" the data,
I am requred to add the first cell value to each of the subsequent cells.
=sumD4-D4 ---This will yield a zero starting point
=sumD5-D4
=SUMD6-D4
=SUMD7-D4
and on and on and on.

I need to subrtact D4 from hundreds of lines of data and there has top be a
better way than doing each one, line by line.