Hi,

I am trying to fill in an excel worksheet by referencing information in another worksheet. I want to have the information fill in on a different worksheet (in order listed in worksheet 1) but have it skip 10 rows in between each reported cell.

I tried doing this but when I fill in the information, for the blank cells, it still counts them as being present and instead of putting in the next subsequent value, i.e., the value from A1, A2, A3 (each being 10 rows apart), it skipps the information and does A1, A12, A23. How do I get Excel to recognize that I want to skip 10 cells in between and continue on with the information rather than just omitting the info.

Please help!

Below is an example what information I am trying to fill-in (in worksheet #2):

Blank row
ID: (content from cell A1 in worksheet #1)
A: (content from cell B1 in worksheet #1)
B: (content from cell C1 in worksheet #1)
C: (content from cell D1 in worksheet #1)
D: (content from cell E1 in worksheet #1)
E: (content from cell F1 in worksheet #1)
F: (content from cell G1 in worksheet #1)
G: (content from cell H1 in worksheet #1)
Blank row
Blank row

Blank row
ID: (content from cell A2 in worksheet #1)
A: (content from cell B2 in worksheet #1)
B: (content from cell C2 in worksheet #1)
C: (content from cell D2 in worksheet #1)
D: (content from cell E2 in worksheet #1)
E: (content from cell F2 in worksheet #1)
F: (content from cell G2 in worksheet #1)
G: (content from cell H2 in worksheet #1)
Blank row
Blank row

etc....(to row 3000).

What custom formula would I use to have it skip 10 rows in between each content and have the information pasted into the 11th row.

I tried using a formula I found online: =IF((MOD(ROW(),11))/11=1,INDEX(SNPs!$A:$A,INT(ROW()/13)+10),"")

But really have no clue what each of the numbers refer to even after changing the numbers around.!

PLEASE HELP!

Thanks so much!