View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Graham is offline
external usenet poster
 
Posts: 155
Default Remote cell reference in formulae

Hi,
With a simple formula replicated over 12 columns, e.g. =SUM(C5:C10) can the
"C10" be referenced from a remote cell, whereby changing the value in the
remote cell to, say C12, will automatically adjust the formula in all 12
columns to recalculate as (C5:C12) to (N5:N12) ?