+ Reply to Thread
Results 1 to 4 of 4

Copy a cell based on condtion(s)

  1. #1
    Registered User
    Join Date
    09-18-2017
    Location
    Dayton
    MS-Off Ver
    Office 16
    Posts
    2

    Question Copy a cell based on condtion(s)

    I have developed a spreadsheet for my department which has tasks associated with employees. The conditions are tasks are Open, In Process, Delayed, or Closed. If the condition is Closed (cell V27) I want to make (Cell B27 blank). I can do that with =IF(V27="Closed","","") However if the condition is In Process, Delayed, or Closed, I want to copy the value in cell B27 in a different section of the sheet. If I do =IF(V27<>"Closed") I get true or false. What can I do with the formula instead of writing VBA code?

    Best Regards,

    Derrick Smith

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Copy a cell based on condtion(s)

    Ok try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    09-18-2017
    Location
    Dayton
    MS-Off Ver
    Office 16
    Posts
    2

    Re: Copy a cell based on condtion(s)

    So, would the formula be something like =IF(V27="Closed",'','')IF(V27="In Process",=M27))?? M27 is the cell is want to copy to B1

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Copy a cell based on condtion(s)

    Try

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro to copy the values in only 2 columns of an excel file based on a condtion to another
    By cbk40060 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2015, 02:57 AM
  2. Replies: 0
    Last Post: 09-13-2015, 03:34 AM
  3. Freezing a value in a cell under certain condtion
    By HELLO2468 in forum Excel General
    Replies: 3
    Last Post: 06-30-2014, 04:04 PM
  4. Match Column based on Condtion
    By foncesa in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-23-2013, 10:07 PM
  5. Copy rows to another sheet on condtion
    By naflas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2011, 07:22 AM
  6. Sum by condtion
    By sqrlking in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-03-2007, 01:36 PM
  7. Autofilter based on date and condtion
    By ap_naveen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2007, 07:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1