I have a workbook with many worksheets.
The primary worksheet simply rearranges selected data from the other worksheets, and then performs calculations on the selected data.
The other worksheets have simple tables.
If a table has an integer, then I want that integer to be copied to the main worksheet. I have no problems with this simple formula.... BUT if the original table has an empty cell, the primary worksheet shows a "0" which in turn corrupts other forumlas.
I need a formula to create an empty cell rather than a "0." I've attached a sample workbook to illustrate my question.
Thanks!
Bookmarks