auto increment from linked formula problem

Hi all, first post here

I would really appreciate if someone could help me out with a problem I am having with copy and pasting a linked formula from a different sheet. The problem occurs as I am trying to list room references on different rows in the new sheet that I have created and as excel is auto incrementing it displays the wrong rooms.

Effectively I am jumping rows in my new sheet but find that the formula that I have created to link a cell from another sheet will follow the row numbers therefore I am missing out rows in-between if that makes sense.

I have searched as much as I can on Google to see if there is a easy solution to this but i cannot find one.

The Formula that I have used is as follows:

='Input Informatio'!A3

This is fine for the first cell, but as the next cell is 4 rows down it will auto increment to the following when I copy and paste:

='Input Information'!A7

but I want it to be:

='Input Information'!A4

I have tried the offset command but only to find that as soon as I copy to the next row the actual amount of rows that i need to subtract has doubled!

I would really like to avoid having to manually change cell numbers as it would probably be faster to re-type the rooms references in. I have approx 120 rooms and I am slow!

I am a total beginner as you can see but eager to learn, can anyone help me out?

Thanks

Try the following formula

=OFFSET(inputinformation!$A$1,(ROW(A3)-3)/4+2,0)

This assumes that you want to link A3 in your second sheet to A3 in "inputinformation", then A7 to A4, A11 to A5 etc.

This may not be the best way to do it, but it will work.

You can use the offset function combine with a simple increment in your work sheet.

See the attached sheet for an example.

Looks like I was too slow and my way was definitely not the easiest.

This is fantastic! thank you all for your replies you have made my day