How to get linked file from worksheet to = "blank"
 

Hi people of the superior power of excel,


I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?




--
seno

How to get linked file from worksheet to = "blank"
 

=IF(ISBLANK(Apple!A1), "", Apple!A1)

It'll return the value of Apple!A1 if a non-blank value exists, but return
blank is Apple!A1 is blank.

--
Location: Sydney
Occupation: Actuarial Consultant (Project Finance/Financial Modeling)


"seno" wrote:


Hi people of the superior power of excel,


I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?




--
seno

How to get linked file from worksheet to = "blank"
 

If you have a formula which returns a blank on that first sheet, then
you will need to do it this way:

=IF(Apple!A1="","",Apple!A1)

Copy across and down as required.

Hope this helps.

Pete

On Apr 16, 9:07*am, seno wrote:
Hi people of the superior power of excel,

I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?

--
seno

How to get linked file from worksheet to = "blank"
 

Thanks a mill

it works.




--
seno

How to get linked file from worksheet to = "blank"
 

You're welcome - thanks for feeding back.

Pete

On Apr 17, 12:45*am, seno wrote:
Thanks a mill

it works.

--
seno