| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Equals formula
I have built a spreadsheet that has my master data (Sheet 1). I have created
a copy of that spreadsheet but with not data (Sheet 2). I want to be able to make any changes in Sheet 1 and have it be reflected in Sheet 2. Since my fields are the same on both sheets I used the formula =sheet1!A2 etc for all the cells I have in sheet 2. My problem is I have many blank cells in Sheet 1 so I get a "0" in Sheet 2. I dont want the "0" value. I want Sheet 2 to be exactly like Sheet 1 but changes made on Sheet 1 are reflected on Sheet 2. Please help. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equals formula
Use
=If(sheet1!A2="","",sheet1!A2) "DataGuy" wrote: I have built a spreadsheet that has my master data (Sheet 1). I have created a copy of that spreadsheet but with not data (Sheet 2). I want to be able to make any changes in Sheet 1 and have it be reflected in Sheet 2. Since my fields are the same on both sheets I used the formula =sheet1!A2 etc for all the cells I have in sheet 2. My problem is I have many blank cells in Sheet 1 so I get a "0" in Sheet 2. I dont want the "0" value. I want Sheet 2 to be exactly like Sheet 1 but changes made on Sheet 1 are reflected on Sheet 2. Please help. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equals formula
Thanks, Sheeloo. I figured it was probably an IF formula...just wasn't sure.
"Sheeloo" wrote: Use =If(sheet1!A2="","",sheet1!A2) "DataGuy" wrote: I have built a spreadsheet that has my master data (Sheet 1). I have created a copy of that spreadsheet but with not data (Sheet 2). I want to be able to make any changes in Sheet 1 and have it be reflected in Sheet 2. Since my fields are the same on both sheets I used the formula =sheet1!A2 etc for all the cells I have in sheet 2. My problem is I have many blank cells in Sheet 1 so I get a "0" in Sheet 2. I dont want the "0" value. I want Sheet 2 to be exactly like Sheet 1 but changes made on Sheet 1 are reflected on Sheet 2. Please help. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| formula equals cell directly above | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| sum formula equals zero | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Linear Mode
