|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 13th, 2004, 02:49 PM
|
|||
|
|||
copying Text
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. 
|
|
#2
July 13th, 2004, 02:54 PM
|
|||
|
|||
|
copying Text
Hi
In the cell on sheet 2 type = and then click the cell in sheet 1 and press Enter. -- Andy. wrote in message ... 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.
|
|
#3
July 13th, 2004, 02:55 PM
|
|||
|
|||
|
copying Text
One way:
=IF(Sheet1!A1="","",Sheet1!A1) In article , wrote: 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.
|
|
#4
July 13th, 2004, 02:58 PM
|
|||
|
|||
|
copying Text
Hi
try =IF('sheet1'!A1="","",'sheet1'!A1) -- Regards Frank Kabel Frankfurt, Germany wrote: 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.
|
|
#5
July 13th, 2004, 02:59 PM
|
|||
|
|||
|
copying Text
Yep!! Missed that one!
-- Andy. "JE McGimpsey" wrote in message ... One way: =IF(Sheet1!A1="","",Sheet1!A1) In article , wrote: 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.
|
|
#6
July 13th, 2004, 03:13 PM
|
|||
|
|||
|
copying Text
Thank you Tons!!
-----Original Message----- Yep!! Missed that one! -- Andy. "JE McGimpsey" wrote in message news:jemcgimpsey- ... One way: =IF(Sheet1!A1="","",Sheet1!A1) In article , wrote: 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. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help on changing text size | Luke Sineath | Page Layout | 7 | June 11th, 2004 05:53 AM |
| How do you insert a page break after a text box | Betty Sutton | Page Layout | 3 | June 9th, 2004 03:05 PM |
| Edit same text in multiple locations | angelo11 | Formatting Long Documents | 2 | May 19th, 2004 06:24 PM |
| copying text across worksheets | Roxy | Setting up and Configuration | 3 | October 15th, 2003 04:36 PM |
Linear Mode
