Results 1 to 8 of 8

copy text from one cell in sheet1 to sheet2

Threaded View

  1. 04-08-2014, 04:21 PM #7
    bibu
    bibu is offline
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    304

    Re: copy text from one cell in sheet1 to sheet2

    You can also add the cell reference if you select the "Sheet1!A1" part of the formula(while the formula is inside a cell) and then go and select the sheet and the cell that you are interested in.
    or try
    =IF(Approved!A1<>"",Approved!A1,"")
    Last edited by bibu; 04-08-2014 at 04:24 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy Data from Sheet1 to Sheet2 depending on input on Sheet1
    By jjmitchell88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2014, 04:33 PM
  2. match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2
    By annielle_09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] If cell value on Sheet1 not found on Sheet2 copy row to Sheet2
    By Yxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2013, 04:15 AM
  4. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  5. Insert test/valle from sheet1 to sheet2 with a text statement.
    By bpope in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2012, 05:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1