Copy cells to another worksheet

[Guest]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Gord Dibben]

Denise

Method 1. Hide the zeros using Tools>Options>View. 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