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.
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
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
