Paste Link
 

Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell, the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do with
the paste link so that both the source cell and pasted cell are also equal to
"". It is because I want both cells are equal to "" at the very beginning.

Thanks in advance.

For me, pating as well as doing =Sheet1!A1 results in "" and not 0. Can you
re-describe the process you are following in detail.

Mangesh



"Freshman" wrote in message
...
Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell, the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do
with
the paste link so that both the source cell and pasted cell are also equal
to
"". It is because I want both cells are equal to "" at the very beginning.

Thanks in advance.

In Sheet2,

instead of putting in A1: =Sheet1!A1
put in A1: =IF(Sheet1!A1="","",Sheet1!A1)

A1 will then appear "blank" until Sheet1's A1 contains a value

To the OP, Freshman: Try feeding back (reply) to responses given to your
posts. Noticed you've made several posts recently, but have yet to see a
single feedback from you within any thread started by you. We're a friendly
bunch of folks here, and this is supposed to be a discussion. If it worked
for you, tell us. If it doesn't, tell us too, and why, so that we could
help you further.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"Mangesh Yadav" wrote in message
...
For me, pating as well as doing =Sheet1!A1 results in "" and not 0. Can
you
re-describe the process you are following in detail.

Mangesh

"Freshman" wrote in message
...
Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell,
the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do
with
the paste link so that both the source cell and pasted cell are also
equal
to
"". It is because I want both cells are equal to "" at the very
beginning.

Thanks in advance.

Hi Max,

I read OP's post "" as text "" and not a blank.

Mangesh



"Max" wrote in message
...
In Sheet2,

instead of putting in A1: =Sheet1!A1
put in A1: =IF(Sheet1!A1="","",Sheet1!A1)

A1 will then appear "blank" until Sheet1's A1 contains a value

To the OP, Freshman: Try feeding back (reply) to responses given to your
posts. Noticed you've made several posts recently, but have yet to see a
single feedback from you within any thread started by you. We're a
friendly
bunch of folks here, and this is supposed to be a discussion. If it
worked
for you, tell us. If it doesn't, tell us too, and why, so that we could
help you further.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"Mangesh Yadav" wrote in message
...
For me, pating as well as doing =Sheet1!A1 results in "" and not 0. Can
you
re-describe the process you are following in detail.

Mangesh

"Freshman" wrote in message
...
Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the
cell
value to Sheet 2, also cell A1. However, after I paste link the cell,
the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I
do
with
the paste link so that both the source cell and pasted cell are also
equal
to
"". It is because I want both cells are equal to "" at the very
beginning.

Thanks in advance.

.. because I want both cells are equal to "" at the very beginning.

My guess was shaped by the line above,
especially the words: "at the very beginning" <g
which, to me, infers the OP was talking about linking blank cells

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mangesh Yadav" wrote in message
...
Hi Max,

I read OP's post "" as text "" and not a blank.

Mangesh

Dear Max,

Thanks for your assistance and your note regarding I haven't replied whether
your answer is useful to you. I'm terribly sorry for my late reply but I
remember I did reply back that the answer is useful to me. Anyway, please
accept my apology and I feel the life is easier for having some experts like
you, who is willing to share their knowledge with Excel idiot like me.

Thanks once again.

Freshman.

"Max" wrote:

In Sheet2,

instead of putting in A1: =Sheet1!A1
put in A1: =IF(Sheet1!A1="","",Sheet1!A1)

A1 will then appear "blank" until Sheet1's A1 contains a value

To the OP, Freshman: Try feeding back (reply) to responses given to your
posts. Noticed you've made several posts recently, but have yet to see a
single feedback from you within any thread started by you. We're a friendly
bunch of folks here, and this is supposed to be a discussion. If it worked
for you, tell us. If it doesn't, tell us too, and why, so that we could
help you further.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

"Mangesh Yadav" wrote in message
...
For me, pating as well as doing =Sheet1!A1 results in "" and not 0. Can
you
re-describe the process you are following in detail.

Mangesh

"Freshman" wrote in message
...
Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell,
the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do
with
the paste link so that both the source cell and pasted cell are also
equal
to
"". It is because I want both cells are equal to "" at the very
beginning.

Thanks in advance.

:)

Mangesh



"Max" wrote in message
...
.. because I want both cells are equal to "" at the very beginning.

My guess was shaped by the line above,
especially the words: "at the very beginning" <g
which, to me, infers the OP was talking about linking blank cells

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mangesh Yadav" wrote in message
...
Hi Max,

I read OP's post "" as text "" and not a blank.

Mangesh

Thanks for the feedback ! Glad to know it helped.

I'm using Outlook Express (OE) to post / read the excel newsgroups, so if
you don't post a reply via the MS' community webpage's "Reply" button
(you're using this medium, I believe), we won't be able to see it. Just
rating the post by pressing the "Yes" button over there doesn't show up
anything over here in OE. A reply is always appreciated, in addition to the
rating <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--