Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference a value to consecutive merged cells
How do I reference a value to consecutive merged cells ( 6 cells merged in a
single column, repeated 8 times downwards) from single unmerged cells in a column in a different worksheet? If I manually reference e.g ='Schedule & Billing'!D9 in the first cell then use the handle bottom right crnr of cell to drag formulae, instead of getting the next cell in the source series, ='Schedule & Billing'!D10 it gets ='Schedule & Billing'!D9 plus 6 ='Schedule & Billing'!D15. Note that 6 is the number of row/cells merged to make one in the destination column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference a value to consecutive merged cells
Try it this way:
=INDIRECT("'Schedule & Billing'!D"&(ROW(A1)*6+3)) and then copy this down. Hope this helps. Pete On Mar 25, 12:54*am, Johnhod wrote: How do I reference a value to consecutive merged cells ( 6 cells merged in a single column, repeated 8 times downwards) from single unmerged cells in a column in a different worksheet? If I manually reference e.g ='Schedule & Billing'!D9 in the first cell then use the handle bottom right crnr of cell to drag formulae, instead of getting the next cell in the source series, ='Schedule & Billing'!D10 it gets ='Schedule & Billing'!D9 plus 6 ='Schedule & Billing'!D15. Note that 6 is the number of row/cells merged to make one in the destination column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consecutive cells pulling data from non-consective cells | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
reference to consecutive worksheets within a workbook | New Users to Excel | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |