Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
While linking to other work sheets
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking one work book to another.... | Excel Worksheet Functions | |||
work sheet linking | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) |