+ Reply to Thread
Results 1 to 6 of 6

Complex copy&paste

  1. #1
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    290

    Complex copy&paste

    Hi guys,

    I'm looking to copy all the values from "CV":
    HmmLhOvKQEymu9O9DB-AmA.png

    & paste them 1 place below:
    ND_My-5BTEOtS_8UEpTcEA.png

    Should be super easy, but it's a complete nightmare! Duplicating the column onto CW, moving the entire column down 1 place, then moving onto CV deletes the original data. Also doing a "find all" (i.e. "TRUE"), then copying & pasting, removes the placement of the data.

    (I imagine the formula used to calculate "TRUE/FALSE" could be adjusted to always allow for the value below it to be true)

    Formula for CV: =IF(BC2=1,IF(AND(L2<=2.88),TRUE),"") (should also point out that the data is ranked. i.e. BC3=2 = "TRUE" if BC1 matches the <=2.88 critera)

    Any help would be much appreciated
    Last edited by Median; 02-01-2018 at 01:02 PM.

  2. #2
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: Complex copy&paste

    Hmm don't really get what you mean. try adding $ sign to your BC3 and L2?

    =IF($BC2=1,IF(AND($L2<=2.88),TRUE),"")

    then try copy again

  3. #3
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    290

    Re: Complex copy&paste

    Sorry, I worded it really badly!!

    Basically, if "Rank 1" is true, I want "Rank 2" to automatically be labeled as true. Vice versa with false

    mb9n9KSGT4CSXnuEx92j4w.png

  4. #4
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: Complex copy&paste

    oh ok sorry i didn't read carefully. so you mean if rank 1 is true the following rank 2 show true as well. and if rank 1 is false rank 2 show false as well is that what you mean?

    How about the remaining rank 3,4,5,6,7 etc
    Last edited by finalazy; 02-01-2018 at 01:27 PM.

  5. #5
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    290

    Re: Complex copy&paste

    If rank 1 is less than or equal to 2.88, show true. Then no matter what rank 2 is, show true also (The key is if rank 1 is true, rank 2 is true)

    If rank 1 is false, then rank 2 is false.

  6. #6
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    290

    Re: Complex copy&paste

    Quote Originally Posted by finalazy View Post
    oh ok sorry i didn't read carefully. so you mean if rank 1 is true the following rank 2 show true as well. and if rank 1 is false rank 2 show false as well is that what you mean?

    How about the remaining rank 3,4,5,6,7 etc
    That's exactly right

    Ranks 3,4,5,6,7 etc are kept blank

+ 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] Complex copy paste
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-23-2015, 02:57 PM
  2. [SOLVED] VBA code: complex search,copy and paste
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-18-2015, 12:50 AM
  3. [SOLVED] Help w/ complex copy paste using VBA
    By rucypher in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2014, 12:42 PM
  4. Complex Copy Paste Delete With Various Rules
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2014, 04:15 AM
  5. Replies: 2
    Last Post: 07-02-2013, 05:47 AM
  6. Complex Copy and Paste Macro
    By Jon Snow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 05:33 AM
  7. Complex Copy and Paste Function
    By DewayAuggy in forum Excel General
    Replies: 2
    Last Post: 02-27-2012, 06:36 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