I want to set up an Excel workbook with multiple worksheets. I want to have
one column repeat on each new worksheet I set up in the workbook so that any
changes or additions made to the column on the original worksheet
automatically update all other worksheets in the workbook. I have tried to
use the "Paste Special" - "Paste Link" commands in the Edit menu, but blank
cells in the original worksheet column show up as "0" in the pasted column
even with the cel format set to "Text".