How do I set up a column to repeat on other worksheets in Excel

[Guest]

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".

 

[Guest]

Hi danmc- In Excel 2002,-Tools, Options, View tab, Zero Values option may help.

PB

 

[Guest]

Boy, do I feel dumb. Forgot all about the View Options. Thanks for your help.