While linking to other work sheets
 

Hello,
I am creating an EXCEL sheet where in each of 4 sheets in that
corresponds to data in sheet1 of a 4 seperate work sheets. I am able
to link the other sheets and getting the data from the other work
sheets also..But where ever there is a blank cell is there , i am
getting a zero. I don't want to appear un necessary zeros in my
consolidated work sheet.
I tried to use the option from
TOOLs --options--view and removed the check against zero values..
This way we can't see the zero values but it occupies the space. so
the memory of the sheet is getting increased as i am going to map for
more number of cells..
So pls let me know the otherway of avoiding zeros while linking to all
the cells of a different work sheet to another sheet of work sheet.

Thanks and Regards,
Raja Shekar

While linking to other work sheets
 

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


Gord Dibben MS Excel MVP

On 21 Feb 2007 06:23:03 -0800, wrote:

Hello,
I am creating an EXCEL sheet where in each of 4 sheets in that
corresponds to data in sheet1 of a 4 seperate work sheets. I am able
to link the other sheets and getting the data from the other work
sheets also..But where ever there is a blank cell is there , i am
getting a zero. I don't want to appear un necessary zeros in my
consolidated work sheet.
I tried to use the option from
TOOLs --options--view and removed the check against zero values..
This way we can't see the zero values but it occupies the space. so
the memory of the sheet is getting increased as i am going to map for
more number of cells..
So pls let me know the otherway of avoiding zeros while linking to all
the cells of a different work sheet to another sheet of work sheet.

Thanks and Regards,
Raja Shekar

While linking to other work sheets
 

Hi Dibben,
Thank you very much for your help.

With Warm Regards,
Raja Shekar

On 21 Feb., 17:42, Gord Dibben <gorddibbATshawDOTca wrote:
=IF(Sheet1!A1="","",Sheet1!A1)

Gord Dibben MS Excel MVP

On 21 Feb 2007 06:23:03 -0800, wrote:



Hello,
I am creating an EXCEL sheet where in each of 4 sheets in that
corresponds to data in sheet1 of a 4 seperate work sheets. I am able
to link the other sheets and getting the data from the other work
sheets also..But where ever there is a blank cell is there , i am
getting a zero. I don't want to appear un necessary zeros in my
consolidated work sheet.
I tried to use the option from
TOOLs --options--view and removed the check against zero values..
This way we can't see the zero values but it occupies the space. so
the memory of the sheet is getting increased as i am going to map for
more number of cells..
So pls let me know the otherway of avoiding zeros while linking to all
the cells of a different work sheet to another sheet of work sheet.

Thanks and Regards,
Raja Shekar- Zitierten Text ausblenden -

- Zitierten Text anzeigen -