linking workbooks using if statements

C

CJ

I'm trying to link one workbook to another ... They are almost identical,
except the first workbook has information that the second workbook doesn't
need ... If I do a direct link, the second workbook is full of a bunch of
zeros ... I tried to use IFBLANK on the second workbook but it puts dollar
signs everywhere ... HELP :)

CJ
 
J

Joel

Try formating the cell in the link the same way the cell is formated in the
other workbook. To make sure the formats are the same you can copy the cell
and then use Paste Special and only paste the format.
 
Top