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

Coachy wrote:
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".



Hi Jack.

If your source cell is A1 on Sheet1, in the target cell insert this
formula:

=IF(Sheet1!A1<"",Sheet1!A1,"")

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy