| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Spread Sheets
I have two spread sheets 1 and 2. I have link multiple rows and columns in
Spread Sheet 1 (from A1 TO D150) to similar area (A1 to D150) in Spread Sheet 2. I Spread Sheet 1, there are several cells that are empty. However, when I link them to Spread Sheet 2, the cell with no value in Spread Sheet 1 shows up as 0.00 in Spread Sheet 2. Short of going cell by cell in Spread Sheet 2 and removing the same, is there any way I can write a code or something that will hide all such values which are 0.00 in Spread Sheet 2? Prasad Gopinath Mississauga |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Spread Sheets
Select the cells and:
Format Cells... Number Custom General;-General;; -- Gary''s Student - gsnu200831 "Prasad Gopinath" wrote: I have two spread sheets 1 and 2. I have link multiple rows and columns in Spread Sheet 1 (from A1 TO D150) to similar area (A1 to D150) in Spread Sheet 2. I Spread Sheet 1, there are several cells that are empty. However, when I link them to Spread Sheet 2, the cell with no value in Spread Sheet 1 shows up as 0.00 in Spread Sheet 2. Short of going cell by cell in Spread Sheet 2 and removing the same, is there any way I can write a code or something that will hide all such values which are 0.00 in Spread Sheet 2? Prasad Gopinath Mississauga |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Excell Spread sheets | Excel Worksheet Functions | |||
| Combining two spread sheets | Excel Discussion (Misc queries) | |||
| Combining two spread sheets | Excel Discussion (Misc queries) | |||
| The history of spread sheets | Charts and Charting in Excel | |||
| exel spread sheets | Excel Worksheet Functions | |||
Linear Mode
