Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking workbooks using if statements
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking workbooks using if statements
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. "CJ" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking statements between spreadsheets | Excel Worksheet Functions | |||
linking workbooks | New Users to Excel | |||
Linking workbooks | Excel Discussion (Misc queries) | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Linking workbooks | New Users to Excel |