i am currently using the correlation formula to test on a large set of data:

e.g.

CORREL(IGR!C233:C262,IIA!C233:C262)

IGR and IIA - they are a pair of data i place in 2 different worksheets, each has set of data, and I need to pull the data of C233 and C262 in IGR and IIA worksheet


and I have many pairs in different worksheets

E.G. RMR and RHR

so I copy the forumla above and hope can only manually adjust the symbol from IGR and IIA to RMR and RHR

when I copy it shift the number down

=CORREL(IGR!C242:[/B]C271,IIA!C242:C271)



from C233 to C242 and C 262 to C271 and I would have to manually adjust it back to C233 and C262


Since I have such a long list of data I need to do, I cannot manually adjust the number every single times

can anyone help or know a function so that I do not need to manually adjust it?

so every time when I copy and paste, it will show me

CORREL(IGR!C233:C262,IIA!C233:C262)

again instead of shifting the number down


many thanks