I am trying to link information in several worksheets so that if I change the
information on the first one, then the others would be updated. My first
worksheet includes various phone numbers (home & mobile). If there is a
phone number available, it links properly - however, if they do not have a
number, then the value comes up as "0". I would rather have the entry blank.
What formula would I use? Currently, it is set up as 'Worksheet1'!B2.
Would it be an "IF/OR" function?
Thank you for your assistance.
Bookmarks