Hi, I'm trying to set up a sheet with the formula ='Sheet1'!E2 in the first
cell.
I would like to be able to copy this to all cells along the row, so that it
increases to ='Sheet1'!E3 then to E4... E5... etc etc. I've tried using
absolute $ signs, but only seem to be able to get the number part to increase
when copying down the column, not across the row! And, conversely, only the
letter part increases along the row (E2... F2.. G2 etc) if I don't use the
$ sign. Any ideas gratefully received, otherwise I have nearly 1000 copy /
pastes plus changing numbers to do!!

Thanks, Richard.