| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking different cells from one sheet to another in same workbook
I've been trying to link certain cells from work sheet A, separated by 7 rows
and same column, to work sheet B. 'Summary Data'!$B$32 is an example of the formula in sheet B but the next cell down would have to be ='Summary Data'!$B$39, 7 cells down from the previous one. how do I add rows to the first formula without having to modify each formula for the next 500 cells down? -- John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cells to another workbook | Excel Worksheet Functions | |||
| Linking cell A in sheet 1 with several cells in sheet 2 | Excel Worksheet Functions | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
| Linking workbook and range protected Excel sheet to Access | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
