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?