We are trying to create a formula in a cell located on one worksheet (TAB) in
a file which will pull the information from a cell in another worksheet (TAB)
in the same file but can't figure out the correct formula that we should be
using.
Ideally what we want to do is to have the second cell display the same
contents as the first cell regardless if it's a number or text but if the
first cell is empty then we want the second cell to be empty as well instead
of displaying a "0".

Also, we are trying to sort the contents in a worksheet but the sorting
function will not work. It just doesn't sort when we go through Data- sort
and make our selections.

Thank you in advance for your help.

Jack