| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
