I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc.... with
the spacing being the same number of cells apart.

='Sheet1'!$A12 goes into Sheet2 cell a24
='Sheet1'!$A13 goes into Sheet2 cell a44
='Sheet1'!$A14 goes into Sheet2 cell a64

I want to be able to paste the formula into Sheet 2 as there are 8 different
items that I need to import per grouping. Any ideas?

Bossman

Here's one way of doing it - put this formula in A4 of Sheet2:

=INDIRECT("'Sheet1'!A"&INT((ROW()+16)/20)+10)

Then copy it into A24, A44, A64 etc of Sheet2.

Hope this helps.

Pete

"Bossman7121" wrote in message
...
I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc....
with
the spacing being the same number of cells apart.

='Sheet1'!$A12 goes into Sheet2 cell a24
='Sheet1'!$A13 goes into Sheet2 cell a44
='Sheet1'!$A14 goes into Sheet2 cell a64

I want to be able to paste the formula into Sheet 2 as there are 8
different
items that I need to import per grouping. Any ideas?

Bossman

Pete ! ! !

Thanks man, that worked perfectly ! !

Much appreciation here. Never used the indirect, and want to learn a little
more about it. Fantastic !

Thanks

Bossman


"Pete_UK" wrote:

Here's one way of doing it - put this formula in A4 of Sheet2:

=INDIRECT("'Sheet1'!A"&INT((ROW()+16)/20)+10)

Then copy it into A24, A44, A64 etc of Sheet2.

Hope this helps.

Pete

"Bossman7121" wrote in message
...
I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc....
with
the spacing being the same number of cells apart.

='Sheet1'!$A12 goes into Sheet2 cell a24
='Sheet1'!$A13 goes into Sheet2 cell a44
='Sheet1'!$A14 goes into Sheet2 cell a64

I want to be able to paste the formula into Sheet 2 as there are 8
different
items that I need to import per grouping. Any ideas?

Bossman

You're welcome, Bossman - thanks for feeding back.

You might also like to look at the OFFSET function in Excel Help -
another way to do it.

Pete

On Dec 6, 1:43 pm, Bossman7121
wrote:
Pete ! ! !

Thanks man, that worked perfectly ! !

Much appreciation here. Never used the indirect, and want to learn a little
more about it. Fantastic !

Thanks

Bossman



"Pete_UK" wrote:
Here's one way of doing it - put this formula in A4 of Sheet2:

=INDIRECT("'Sheet1'!A"&INT((ROW()+16)/20)+10)

Then copy it into A24, A44, A64 etc of Sheet2.

Hope this helps.

Pete

"Bossman7121" wrote in message
...
I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc....
with
the spacing being the same number of cells apart.

='Sheet1'!$A12 goes into Sheet2 cell a24
='Sheet1'!$A13 goes into Sheet2 cell a44
='Sheet1'!$A14 goes into Sheet2 cell a64

I want to be able to paste the formula into Sheet 2 as there are 8
different
items that I need to import per grouping. Any ideas?

Bossman- Hide quoted text -

- Show quoted text -