Home |
Search |
Today's Posts |
#2
|
|||
|
|||
If the row/column/cell insertion is to be in the same location on each sheet,
select one sheet then Shift-Click the tab for the second sheet (assuming they are consecutive sheets in the workbook), *then* insert you rows/columns/cells. (If not consecutive sheets, use Ctrl-Click.) HTH |:) "Jon1205" wrote: I have a workbook with two worksheets. Some columns in sheet1 I want to link to sheet2. Is there a way that I can link a column so that if I end up adding a row in sheet1, the data in the linked columns in sheet2 shift down. I have tried using a dynamic range, but my empty cells are filled with a zero. Is there a way to correct this problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Linking sheets | Excel Discussion (Misc queries) | |||
Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |