| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Data from Specified Cell Series
I have data in a series of cells such as B10; B23; B36; B49; (every 13th row
through B2090) and correlating data in cells I19; I32; I45; I58 (every 13th row through I2103). I want to copy the cell contents to a new worksheet in the same workbook where A10 would transfer to A2 on the new worksheet; I19 would transfer to B2; A23 to A3; I32 to B3; etc. I know this can be done one at a time with Paste Special or just copy and paste. I want to have a formula that I can replicate down each column that will return the correct data. Help please! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return Data from Specified Cell Series
One way ..
Assume source data as posted is in Sheet1 In say, Sheet2, Place In A2: =OFFSET(Sheet1!$B$10,ROW(A1)*13-13,) In B2: =OFFSET(Sheet1!$I$19,ROW(A1)*13-13,) Select A2:B2, copy down 160 rows or until zeros appear, signalling exhaustion of data Then freeze the values by selecting cols A & B, do an in-place: copy paste special Check "Values" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cheri" wrote: I have data in a series of cells such as B10; B23; B36; B49; (every 13th row through B2090) and correlating data in cells I19; I32; I45; I58 (every 13th row through I2103). I want to copy the cell contents to a new worksheet in the same workbook where A10 would transfer to A2 on the new worksheet; I19 would transfer to B2; A23 to A3; I32 to B3; etc. I know this can be done one at a time with Paste Special or just copy and paste. I want to have a formula that I can replicate down each column that will return the correct data. Help please! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return Data from Specified Cell Series
Hi Max,
You are amazing!!! Worked great! Thanks, Cheri "Max" wrote: One way .. Assume source data as posted is in Sheet1 In say, Sheet2, Place In A2: =OFFSET(Sheet1!$B$10,ROW(A1)*13-13,) In B2: =OFFSET(Sheet1!$I$19,ROW(A1)*13-13,) Select A2:B2, copy down 160 rows or until zeros appear, signalling exhaustion of data Then freeze the values by selecting cols A & B, do an in-place: copy paste special Check "Values" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cheri" wrote: I have data in a series of cells such as B10; B23; B36; B49; (every 13th row through B2090) and correlating data in cells I19; I32; I45; I58 (every 13th row through I2103). I want to copy the cell contents to a new worksheet in the same workbook where A10 would transfer to A2 on the new worksheet; I19 would transfer to B2; A23 to A3; I32 to B3; etc. I know this can be done one at a time with Paste Special or just copy and paste. I want to have a formula that I can replicate down each column that will return the correct data. Help please! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return Data from Specified Cell Series
Great it worked out fine, Cheri !
Thanks for the feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cheri" wrote: Hi Max, You are amazing!!! Worked great! Thanks, Cheri |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start & End of the data series | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| have a cell return one of severl lists based on data from another | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
