Trying to move every nth cell from Sheet1 to Sheet2

[J312S]

Hi,
I am trying to move every 6th cell from Sheet1 column K into consecutive columns in Sheet2 Column B. Example I want: Sheet1 Cells K23, K29, K35, K41... to go into Sheet2 B2,B3,B4,....
Sheet2 Sheet1
B2 = K23
B3 = K29
B4 = K35

Thanks for your help!

 

[Somendra Misra]

Hi,

See if this helps, otherwise write back.

Regards,

 

[J312S]

Thanks,
I couldn't figure out how to get the formula to work. I would like to be able to just copy down going forward in sheet2 from sheet 1

Thanks

 

[Somendra Misra]

See your file.

Regards,

 

[J312S]

Thank you works great. Is there a way I can copy the formula into other excel sheets with the same layout? When I tried it comes up with a value of 0.00

 

[Somendra Misra]

Yes it is possible to copy the formula to any sheet. But here are the conditions:

1. Look carefully how the ref. are pointed in the formula and adjust them in your new sheets.
2. The formula is array formula, which requires a special key-stroke, i.e. normal formula are entered using ENTER, but here you have to press 3 keys, Ctrl+Shift+Enter.

Regards,