Dear all,

I would like to 'auto number' a column downwards.
IN Column A1 information is shown from 'Input Sheet 2'!A1
If I use the autofill in column A2 it will show 'Input Sheet2'!A2, however I want this to be 'Input Sheet2'!B1 and in A3 it should be C1 and so forth.

I am not able to fix this with the $ sign.

Anyone any idea?