Annoying Cut/Paste problem!!!

[adambc]

This was my original post My brain won't work! - at the time the requirement went away - but now it's back!!!

On WS1 I have a list starting in cell B20 (there is a header in B19) ...

On WS2 I have a "table" with 4 columns starting in cell B15 ...

I want to populate the table like this ...

WS2/B15 = WS1/B20 / WS2/C15 = WS1/B21 / WS2/D15 = WS1/B22 / WS2/E15 = WS1/B23
WS2/B16 = WS1/B24 / WS2/C16 = WS1/B25 / WS2/D16 = WS1/B26 / WS2/E16 = WS1/B27
etc etc

BUT ... I must be able to CUT/Paste the list on WS1 and update the "table" on WS2 such that the above remains ...

... I have used OFFSET as suggested in my original post ie =OFFSET(WS1!$B$20, (((ROW()-15)*4)-1)+(COLUMN()-1),0,1,1) ...

... and I can now CUT/Paste the list on WS1 to my hearts content, PROVIDED I DON'T CUT/PASTE WS1/$B$20 - if I do the $B$20 gets reset to wherever I Paste it!!!

Any ideas???

Thanks ...

 

[jasonb75]

Any ideas???

Offset from the header instead of the first data row.
Best guess with the information provided.

=OFFSET(WS1!$B$19, (((ROW()-1)*4))+(COLUMN()-1),0,1,1)

 

[adambc]

Of course ...

Seems to be working OK ...

Thanks ...