| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells...easy one
Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when there is nothing entered in cell A1, D5 is blank, mine show up as 0?? "FSt1" wrote: hi, you can use a formula. if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell d5, then in D5 put the formula =sheet1!A1. what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5. NO macro needed. Regards FSt1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells...easy one
You could use an IF statement.
=IF(A1="","",A1) So, if A1 is blank, then return blank, else return value of A1. HTH, Elkar "SLKoelker" wrote: Hi FSt1: I was looking for a way to link cells on the same sheet and your response to this post helped, however is there a way to make it so that when there is nothing entered in cell A1, D5 is blank, mine show up as 0?? "FSt1" wrote: hi, you can use a formula. if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell d5, then in D5 put the formula =sheet1!A1. what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5. NO macro needed. Regards FSt1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells...easy one
THANK YOU........ It worked perfectly.
Thanks so much Elkar! "Elkar" wrote: You could use an IF statement. =IF(A1="","",A1) So, if A1 is blank, then return blank, else return value of A1. HTH, Elkar "SLKoelker" wrote: Hi FSt1: I was looking for a way to link cells on the same sheet and your response to this post helped, however is there a way to make it so that when there is nothing entered in cell A1, D5 is blank, mine show up as 0?? "FSt1" wrote: hi, you can use a formula. if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell d5, then in D5 put the formula =sheet1!A1. what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5. NO macro needed. Regards FSt1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easy way to swap the contents of two cells in Excel? | Excel Discussion (Misc queries) | |||
| Two Reference Cells in VLOOKUP, Probably easy but .... | Excel Discussion (Misc queries) | |||
| Easy way to shade cells | Excel Discussion (Misc queries) | |||
| Is there an easy way to count when adjacent cells contain same data? | Excel Worksheet Functions | |||
| is there an easy way to move parts of cells around | Excel Discussion (Misc queries) | |||
Linear Mode
