I have setup a a worksheet that maps the input of an adjacent worksheet (in the same workbook). This "mapped" worksheet is in a format that will allow it to be converted to a QuickBooks .iif file format (using an Excel add in product). Here is my question: Many of the cells in the primary worksheet have no value in them, and when they are mapped (simply by linking their contents into the second worksheet cells), a zero is placed in the target cell. This zero wrecks havoc when the mapped worksheet is exported to create the .iif file.
How can I create a conditional formula that simply places the contents of the linked cell from the original worksheet into the cell of the mapped worksheet but leaves it empty (no zero, just blank) when there is no input in the orginal. By the way, the cells in question are formated as "General" in both the original and mapped worksheet.
Thanks very much for any help!
Bookmarks