Locking cells together/creating relationship

[Tyson79]

I hope this makes sense!

I have a workbook with several sheets.

Sheet two has six columns, the first 2 of which contain the offset rule linking them to corresponding columns in sheet one.

However, the remaining 4 columns remain empty for data entry - because they do not have the offset rule, they do not move with their neighbouring cells - is there anyway i can create a relationship between them or lock them together so when the first two move the remaining four move with them?

Thank you

 

[DauntingGecko]

Why not base your offset on the other offsets?

 

[Tyson79]

The problem is, when it comes to excel i don't know anything. I know what i want it to do, i just don't know how to do it - or explain it very well

I'm not sure what you mean by "Why not base your offset on the other offsets?"

The remaining four columns need to remain empty as i need to populate them with data at a later date.