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.![]()
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.![]()
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
i am creating a program which needs inpust from the clipboard, so i want the computer to do it.![]()
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.
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
so what you reall want is some vba code to copy something so the other app. can retrieve it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks