+ Reply to Thread
Results 1 to 6 of 6

Copy to clipboard using IF in excel

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    chennai,india
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy to clipboard using IF in excel

    i have compared two cells and returned a value to a third cell, now i want to copy the value in the third cell to the clipboard only if it returns a value 1. i am not able to find a solution, your help will be appreciated.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy to clipboard using IF in excel

    what? cant you just use copy?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-22-2009
    Location
    chennai,india
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copy to clipboard using IF in excel

    i am creating a program which needs inpust from the clipboard, so i want the computer to do it.

  4. #4
    Registered User
    Join Date
    12-19-2008
    Location
    CA
    Posts
    64

    Re: Copy to clipboard using IF in excel

    Can you copy and paste into another column using Paste Special: Paste Values? And then use that to copy into the clip board?

    EDIT: Scratch that... I mis read the first post.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,006

    Re: Copy to clipboard using IF in excel

    You can add FILTER into first row, chose when third column is 1 and then sellect and copy-paste spetial -> Values and you get only that data...
    Never use Merged Cells in Excel

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy to clipboard using IF in excel

    so what you reall want is some vba code to copy something so the other app. can retrieve it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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