Hi All,

I encountered a problem that almost pulled all my hair out.
I work on two sheets. In sheet1 I have table that contains in every row a name of person and in every column a certain number correct for every individual. In sheet2 I have other table, for every individual collating some of the information from sheet1.
It looks like:

Name
A1 =sheet1!B2
A2 =sheet1!C2

If I highlight the table and drag it down to copy the formula I will get something like:

Name
A3 =sheet1!B5
A4 =sheet1!C5

But what I want to get is:

Name
A3 =sheet1!B3
A4 =sheet1!C3

Is there a way to set it up so when I drag the table down the row will increase every 1 not every 3?

Thank you very much for you thoughts.