In the file: Index_Log, I have a list for contract drawings generated on Tab-1 that I will be doing monthly updates on.
Background:
For every monthly update, I'll create a new tab to track updates and for this purpose I'll number the tabs sequentially such as Tab-2, Tab-3 etc...
I want to link values from the source Tab-1 beginning with Cell E3 to Tab-2 for example and instead of having a cell return a value of zero '0' on the new tab, I want it left blank.
When I link values from Tab-1 to Tab-2, the blank entries from Tab-1 result in a 'zero' (0) on Tab-2 and I want the new tab to also display an empty/blank cell.
I need blank cells because the most recent value updates are shown in col. D whose default value should = 'As-Bid' for blank cells, thus having a '0' in col. D is incorrect.
Attempted Formula on Tab-2:
=IF('TAB-1'!I3=" "," ",'TAB-1'!I3)
Snippet below from Tab-2
I found this formula from a similar topic on this forum, but I am obviously entering it wrong as Cell I3 results in zero (0) instead of being blank.
Thank you in advance for reading and taking the time to help.
Background:
For every monthly update, I'll create a new tab to track updates and for this purpose I'll number the tabs sequentially such as Tab-2, Tab-3 etc...
I want to link values from the source Tab-1 beginning with Cell E3 to Tab-2 for example and instead of having a cell return a value of zero '0' on the new tab, I want it left blank.
When I link values from Tab-1 to Tab-2, the blank entries from Tab-1 result in a 'zero' (0) on Tab-2 and I want the new tab to also display an empty/blank cell.
I need blank cells because the most recent value updates are shown in col. D whose default value should = 'As-Bid' for blank cells, thus having a '0' in col. D is incorrect.
Attempted Formula on Tab-2:
=IF('TAB-1'!I3=" "," ",'TAB-1'!I3)
Snippet below from Tab-2
I found this formula from a similar topic on this forum, but I am obviously entering it wrong as Cell I3 results in zero (0) instead of being blank.
Thank you in advance for reading and taking the time to help.