Results 1 to 4 of 4

If cell contains text value then copy+paste choice cells from that row

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2020
    Location
    London
    MS-Off Ver
    Excel MAC
    Posts
    2

    If cell contains text value then copy+paste choice cells from that row

    Hi all,

    Hoping someone can assist.

    Please see attached spreadsheet; should a "NO" be placed in column J (Converted Quote)

    Is it possible to copy and paste some of the cells on that row to another location on the spreadsheet?

    (in this case, the bottom right of the spreadsheet where it says "Service Enquiries Not Converted, Now WIP"

    So in short; the file check if the cell with “Yes” or “No” in it is updated and if it is updated and now says “Yes” to grab the contents of the cells you want and copy and paste them into that table.

    Should a "NO" be placed in Column J, ideally:

    T25:41 - copies cells from C3 onwards

    U25:41 - copies cells from F3 onwards
    Attached Files Attached Files
    Last edited by J288; 10-27-2020 at 02:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] advice required on Count if
    By arindamsenaxa in forum Excel General
    Replies: 5
    Last Post: 01-29-2019, 02:13 AM
  2. [SOLVED] advice required on ratio calculation formula
    By Slipa in forum Excel General
    Replies: 6
    Last Post: 06-22-2017, 06:48 AM
  3. [SOLVED] Streamlining - Advice required please
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 12:21 PM
  4. Help Please ... Visual basic advice required
    By ZARAKIAN_58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2011, 03:29 PM
  5. Excel userform on a website - Advice required
    By PRodgers in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 09:54 AM
  6. Advice required for this function
    By localhost in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2008, 06:04 AM
  7. Replies: 1
    Last Post: 08-21-2006, 07:20 PM

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