Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy only the month from a date | Excel Worksheet Functions | |||
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel |