copying Text

Guest · Jul 13, 2004

how can i set a cell on sheet 2, to copy text from sheet 1
and if the cell on sheet 1 is blank then so is the cell on
sheet 2.

Andy B · Jul 13, 2004

Hi

In the cell on sheet 2 type = and then click the cell in sheet 1 and press
Enter.

JE McGimpsey · Jul 13, 2004

One way:

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

Frank Kabel · Jul 13, 2004

Hi
try
=IF('sheet1'!A1="","",'sheet1'!A1)

Andy B · Jul 13, 2004

Yep!! Missed that one!

--
Andy.

JE McGimpsey said:
One way:

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

Guest · Jul 13, 2004

Thank you Tons!!

-----Original Message-----
Yep!! Missed that one!

--
Andy.

.

SUMPRODUCT formula I think w/ wild card & number vs number as text	8	Feb 18, 2014
Excel VBA to move cells to sheet2 based on selection in sheet1	0	Aug 3, 2018
Formatting does not follow when copying from one cell to another	6	Apr 7, 2010
Excel Move or Copy Stopped Working?	0	Aug 19, 2023
add hyperlink using sheet names and cells(i,j)	3	Dec 31, 2013
Update cell value based on name and specific date	1	Jan 8, 2015
Worksheet linking	2	Feb 3, 2010
using the =page! feature to transpose a row to column	0	Jan 25, 2014

Ask a Question