I'm having the hardest time with this:
I have two worksheets in an excel file: I'll call them Tab1 and Tab2.
Cells in Tab2 link to cells in Tab1.
I want the cells in Tab2 to display a hyphen "-" when the referenced cell in Tab1 is BLANK/completely empty.
If the referenced cell in Tab1 has any data whatsoever (1, 2, a 0/zero), it should carry over into Tab2.
Any help is greatly appreciated.
.
Bookmarks