I am trying to autofill a series of cells from another Sheet but cannot get the autofill to follow the intended pattern correctly.

The information in the first cell comes from =’Sheet1′!A1 

I want the autofill in the next cell to also be from ‘sheet1′ but instead of =’sheet1′!A2, It needs to be =’sheet1’!A11. It skips 10 cells, then the following cell should be the information in A21, A31, A41 and so on.

The autofill function is not recognizing this pattern.  I have tried many ways to get this to work but there seems to be difficulty in the fact that the info in the cell is coming from another Sheet or cell.  How can I get this to work? 

​I am trying to autofill a series of cells from another Sheet but cannot get the autofill to follow the intended pattern correctly. The information in the first cell comes from =’Sheet1′!A1 I want the autofill in the next cell to also be from ‘sheet1′ but instead of =’sheet1′!A2, It needs to be =’sheet1’!A11. It skips 10 cells, then the following cell should be the information in A21, A31, A41 and so on.The autofill function is not recognizing this pattern.  I have tried many ways to get this to work but there seems to be difficulty in the fact that the info in the cell is coming from another Sheet or cell.  How can I get this to work?   Read More

​