Denise
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 Dibben Excel MVP
On Thu, 21 Apr 2005 12:06:01 -0700, Denise
wrote:
When I do this it shows a zero in the cells where there is nothing typed in
the first. I need for the cell to be blank if it is blank of the first sheet.
"Carole O" wrote:
Open up both worksheets and set them side by side on your screen. In the
receiving worksheet, go to the cell you want to receive the data, type =.
Then click on the sending cell so the block. When the border "moves", press
the Enter key.
Hope this helps,
Carole O
"Denise" wrote:
I want to set up a worksheet that will transfer the information that I am
putting in it to another worksheet. I will not need all of the columns in
the second sheet.
Is there a way I can do this. I tried the copy and paste link but when I do
that there are zeros in those cells. I need for those to be blank until I
fill in something on the master sheet.
Thanks for any help.
|