Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill cells from non-adjacent cells
I am populating a worksheet with values from another worksheet.
For example the cells D6:Y6 on Sheet1, need results from various cells on Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note: There is data in the cells between cell E15 and J15 and so on) Is there a simpler way to 'auto-fill' these cells, or is there some quicker way of accomplishing this rather than by cut and paste, or swapping between worksheets for each cell. -- Cheers Abes |
#2
|
|||
|
|||
Try...
D6, copied across: =OFFSET(Sheet2!$E$15,0,(COLUMN()-COLUMN($D$6)+1)*5-5) Hope this helps! In article , "Abes" wrote: I am populating a worksheet with values from another worksheet. For example the cells D6:Y6 on Sheet1, need results from various cells on Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note: There is data in the cells between cell E15 and J15 and so on) Is there a simpler way to 'auto-fill' these cells, or is there some quicker way of accomplishing this rather than by cut and paste, or swapping between worksheets for each cell. |
#3
|
|||
|
|||
Thanks Domenic - seems to work a treat.
Cheers "Domenic" wrote: Try... D6, copied across: =OFFSET(Sheet2!$E$15,0,(COLUMN()-COLUMN($D$6)+1)*5-5) Hope this helps! In article , "Abes" wrote: I am populating a worksheet with values from another worksheet. For example the cells D6:Y6 on Sheet1, need results from various cells on Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note: There is data in the cells between cell E15 and J15 and so on) Is there a simpler way to 'auto-fill' these cells, or is there some quicker way of accomplishing this rather than by cut and paste, or swapping between worksheets for each cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
need to fill cells automatically | Excel Worksheet Functions | |||
how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |