Ok, you could replace the formula in A1 with this:
=$A$10+OFFSET($A$10,COLUMNS($A:A),)
Copy A1 across, and you'd the required results

Take a moment to press the "Yes" button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"Ken G." wrote:
OK. Simplified, the formula in say A1 is =$A$10+ A11
Data exists in column A in cells A11....A15

When I copy the formula in A1 across B1, C1, D1 & E1 it will become
$A$10+B11, $A$10+B12, $A$10+B13 etc. whereas I want it to be $A$10+A11,
$A$10+A12 etc.