Andy,

No way. If you're copying the H Walsh row down, =WS2!G6 should definitely
become G7. Unless, by chance, it's really =WS2!$G$6, or G$6.
--
Earl Kiosterud
www.smokeylake.com

"Andy Brander" wrote in message
...
I have a simple table where data is gathered from another worksheet (lets
call it WS2), the formulas look something like:
Col A Col B Col C Col D
J Smith =WS2!G4 =WS2!G7 =WS2!G10
B Jones =WS2!G5 =WS2!G8 =WS2!G11
H Walsh =WS2!G6 =WS2!G9 =WS2!G12

When I duplicate a row (in order to create a new one) I was expecting the
references in the formula to automatically adjust, e.g. the cell
references
would become 4,5,6,7 in column B, 8,9,10,11 in Col C and 12,13,14,15 in
Col
D. But they don't - the cell references in Col B are 4,5,6,6 and Col C &
D
are unchanged.

I am sure they automatically adjusted in another spreadsheet but I cannot
figure out what I am doing differently. The above is an example, the
actual spreadsheet is very large hence me wanting to avoid manually
changing
all the formule. Can anyone help?