Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
I have two spreadsheets linked together as vacation planners....the worksheet
cells that the link is copied to default to "0"....I am wondering if there is a way to still have the sheets linked but that the cell stays blank vs. a "0" and would only reflect the actual entry once entered in the main spreadsheet. Thank you, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
Hi
Something like this : =if(sheet1!a1="","",your formula. change range to your need. HTH John "OC" wrote in message ... I have two spreadsheets linked together as vacation planners....the worksheet cells that the link is copied to default to "0"....I am wondering if there is a way to still have the sheets linked but that the cell stays blank vs. a "0" and would only reflect the actual entry once entered in the main spreadsheet. Thank you, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
I'm sure this works ... but not sure I understand what to do ... sorry to ask
I'm assuming I paste this formula in the main workbook. My range is from c20:m383. Can you help? "John" wrote: Hi Something like this : =if(sheet1!a1="","",your formula. change range to your need. HTH John "OC" wrote in message ... I have two spreadsheets linked together as vacation planners....the worksheet cells that the link is copied to default to "0"....I am wondering if there is a way to still have the sheets linked but that the cell stays blank vs. a "0" and would only reflect the actual entry once entered in the main spreadsheet. Thank you, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
HI OC
The cells that are showing 0 there is a formula in those cells. Just add what i typed to your formula e.g. =if(sheet1!a1="","", HTH John "OC" wrote in message ... I'm sure this works ... but not sure I understand what to do ... sorry to ask I'm assuming I paste this formula in the main workbook. My range is from c20:m383. Can you help? "John" wrote: Hi Something like this : =if(sheet1!a1="","",your formula. change range to your need. HTH John "OC" wrote in message ... I have two spreadsheets linked together as vacation planners....the worksheet cells that the link is copied to default to "0"....I am wondering if there is a way to still have the sheets linked but that the cell stays blank vs. a "0" and would only reflect the actual entry once entered in the main spreadsheet. Thank you, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
In C20 enter =IF(Sheet1!A1="","",Sheet1!A1)
Means if Sheet1!A1 is blank, return a blank, else return what is in A1 If in another workbook, preface the range with the workbook name also =IF([Book2]Sheet1!A1="","",[Book2]Sheet1!A1) Copy across to M20 then down to M383 Gord Dibben MS Excel MVP On Mon, 2 Feb 2009 09:44:01 -0800, OC wrote: I'm sure this works ... but not sure I understand what to do ... sorry to ask I'm assuming I paste this formula in the main workbook. My range is from c20:m383. Can you help? "John" wrote: Hi Something like this : =if(sheet1!a1="","",your formula. change range to your need. HTH John "OC" wrote in message ... I have two spreadsheets linked together as vacation planners....the worksheet cells that the link is copied to default to "0"....I am wondering if there is a way to still have the sheets linked but that the cell stays blank vs. a "0" and would only reflect the actual entry once entered in the main spreadsheet. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |