Linking Sheets
 

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?

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?