Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I link columns from one worksheet to another in the workbo.
I am trying to enter data in a column of one worksheet and have the data show
up in another worksheet in the same workbook. I have tried to highlite the colum and use "=" : highlite the other colum on the other wroksheet and hit <enter. This does not work. Any suggestions? |
#2
|
|||
|
|||
Feather
AFAIK this cannot be done on entire columns. Enter the = sign in A1 then switch to other sheet and select A1 and ENTER. Now just drag/copy that formula down as far as you wish. Gord Dibben Excel MVP On Tue, 19 Apr 2005 10:53:02 -0700, Featherstony wrote: I am trying to enter data in a column of one worksheet and have the data show up in another worksheet in the same workbook. I have tried to highlite the colum and use "=" : highlite the other colum on the other wroksheet and hit <enter. This does not work. Any suggestions? |
#3
|
|||
|
|||
Gord Dibben
Thanks Works good, however I am using dates. When no date is entered I get 1/00/00. Is there a way to correct this. Instead of 1/0/00 have the cell blank? "Gord Dibben" wrote: Feather AFAIK this cannot be done on entire columns. Enter the = sign in A1 then switch to other sheet and select A1 and ENTER. Now just drag/copy that formula down as far as you wish. Gord Dibben Excel MVP On Tue, 19 Apr 2005 10:53:02 -0700, Featherstony wrote: I am trying to enter data in a column of one worksheet and have the data show up in another worksheet in the same workbook. I have tried to highlite the colum and use "=" : highlite the other colum on the other wroksheet and hit <enter. This does not work. Any suggestions? |
#4
|
|||
|
|||
Feather
Method 1. Hide the zeros using ToolsOptionsView. Uncheck "zero values" Method 2. Use an IF formula in the linked cells. =IF(ISBLANK(Sheet1!A1,"",Sheet1A1) If you have a great whack of these to do, run this macro on the selected range. Sub ISBLANK_Add() Dim myStr As String Dim cel As Range For Each cel In Selection If cel.HasFormula = True Then If Not cel.Formula Like "=IF(ISBLANK*" Then myStr = Right(cel.Formula, Len(cel.Formula) - 1) cel.Value = "=IF(ISBLANK(" & myStr & "),""""," & myStr & ")" End If End If Next End Sub Gord On Tue, 19 Apr 2005 11:53:04 -0700, Featherstony wrote: Gord Dibben Thanks Works good, however I am using dates. When no date is entered I get 1/00/00. Is there a way to correct this. Instead of 1/0/00 have the cell blank? "Gord Dibben" wrote: Feather AFAIK this cannot be done on entire columns. Enter the = sign in A1 then switch to other sheet and select A1 and ENTER. Now just drag/copy that formula down as far as you wish. Gord Dibben Excel MVP On Tue, 19 Apr 2005 10:53:02 -0700, Featherstony wrote: I am trying to enter data in a column of one worksheet and have the data show up in another worksheet in the same workbook. I have tried to highlite the colum and use "=" : highlite the other colum on the other wroksheet and hit <enter. This does not work. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
Link in worksheet | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |