Need formula to copy data and skip rows automatically.

Hello,

I need to copy data from sheet B to sheet A, easy right?

Below is what I am trying to accomplish, basically I want to enter the formula once and then drag it to the right skipping 13 rows on sheet b each time. Thank you for your help!

Sheet A
D19 ='Sheet B'!K3
E19 ='Sheet B'!K16
F19 ='Sheet B'!K29
G19 ='Sheet B'!K42
H19 ='Sheet B'!K55
I19 ='Sheet B'!K68
J19 ='Sheet B'!K81

Try this...

Entered in D19 and copied across as needed:

=OFFSET('Sheet B'!$K3,COLUMNS($D19:D19)*13-13,0)

Here's another one...

With this one you have to define the range. I've used K3:K200. Adjust for the correct end of range.

=INDEX('Sheet B'!$K3:$K200,COLUMNS($D19:D19)*13-13+1)