How do I copy text using a formula between worksheets in Excel?
 

I have a workbook with several worksheets I am attempting to have a
representative's name copy over to a "total" sheet using a formula. Can
anyone help me?

How do I copy text using a formula between worksheets in Excel?
 

=IF(Sheet1!A1<"",Sheet1!A1,"")
OR in Sheet2!A1
=Sheet1!A1

"Guero" wrote:

I have a workbook with several worksheets I am attempting to have a
representative's name copy over to a "total" sheet using a formula. Can
anyone help me?

How do I copy text using a formula between worksheets in Excel
 

This is not working for me. Maybe I do not have enough knowledge of this
function. Please explain how to use. Thank you for your help

"ufo_pilot" wrote:


=IF(Sheet1!A1<"",Sheet1!A1,"")
OR in Sheet2!A1
=Sheet1!A1

"Guero" wrote:

I have a workbook with several worksheets I am attempting to have a
representative's name copy over to a "total" sheet using a formula. Can
anyone help me?