Copy cells to another worksheet
 

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.

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.

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.

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.