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

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

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

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

PB


"danmc1000" wrote:

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

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

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

"PancakeBatter" wrote:

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

PB


"danmc1000" wrote:

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