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.