Forum Discussion
Copy and paste checkable text
Dear my friends
I've created this with excel.
Now i want to copy and paste names that I've selected as you see.
How can we copy and paste these tree names to another text file.
I've created this with excel.
Now i want to copy and paste names that I've selected as you see.
How can we copy and paste these tree names to another text file.
Oh Sorry!
That's because the code depends on the row number of the last filled cell in the Notes column to identify the last row of the selected names.
Now, I've updated it to compare the Notes column and the Names column and choose the column in which the last row number is greater than the other.
Consequently, even if you have a note without a name, it will be copied!
Hope that helps
pls see attached file.
hope you can work something out of it.
thanks..
- Dear Lorenzo Kim
Thank you very much for your fast reply.
Yes it works greatly.
But now I have another request and i am very happy if you can help me because I'm beginner in excel.
In coloum I i want to have a lot of check box bottom from top (1) to bottom (for instance up to1000)
In coloum H I want to write the my names.
and finaly In column G I need to write numbers or another text ( but sometimes) and i need to see it in paste part when i turn on check box.
Please download attached file for more information.
Thanks again - Dear Lorenzo Kim
Thank you very much for your fast reply.
Yes it works greatly.
But now I have another request and i am very happy if you can help me because I'm beginner in excel.
In coloum I i want to have a lot of check box bottom from top (1) to bottom (for instance up to1000)
In coloum H I want to write the my names.
and finaly In column G I need to write numbers or another text ( but sometimes) and i need to see it in paste part when i turn on check box.
Please download attached file for more information.
Thanks againmy suggestion is that you put this query as another conversation title..
say, How To Copy CheckBoxes Down..good luck
pls see attached file.
I don't know if this is what you need.
- Thank you very much
But where is the copy button ?Oops sorry for that!
I have inserted it again into the worksheet.
- Thank you very much for your help
But where is Dave?
I told that SOMETIMES i need to write something in Notes coloum.
Please find attach.
I selected Dave but it will not copy!
Why?
Please help me to solve it.
ALWAYS i will write something in Names column.
But SOMETIMES I write something in Notes coloum.
I need to copy Dave even there is nothing in Notes coloum.
Thank you very much for your help
