View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Elhatton Tim Elhatton is offline
external usenet poster
 
Posts: 8
Default automatically add to cell formula

Here is my question:

1 2 3 4

$1.15 $1.17 $1.59 $1.43

'Data'!$G11 'Data'$G33 'Data'$G55 ????

I want to be able to automatically drag my formula across....each time
adding 22 to the cell reference.....so the next cell formula above would be
'Data'$G77...?
Right now I am doing this manually....any ideas?
Thanks