copy data from sheet1 to sheet but in varying positons
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 |
copy data from sheet1 to sheet but in varying positons
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 |
copy data from sheet1 to sheet but in varying positons
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 |
copy data from sheet1 to sheet but in varying positons
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 - |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com