Forum Discussion

tube.designing's avatar
tube.designing
Copper Contributor
Oct 20, 2018
Solved

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.
excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Oct 25, 2018

    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

18 Replies

Sort By
      • tube.designing's avatar
        tube.designing
        Copper Contributor
        Oct 25, 2018
        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
    • tube.designing's avatar
      tube.designing
      Copper Contributor
      Oct 21, 2018
      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
      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Oct 22, 2018

        Hi,

         

        I think the best way is to use a macro.

        So my suggested one is this:

        Sub CopySelectedNamesToAnotherSheet()
            On Error Resume Next
            Application.ScreenUpdating = False
            Range("J4").Select
            Selection.AutoFilter Field:=4, Criteria1:="TRUE"
            ActiveCell.CurrentRegion(1, 1).Activate
            Range("G2:H" & ActiveCell.End(xlDown).Row).Copy
            Sheets("Sheet2").Select
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                :=False, Transpose:=False
            Sheets("Sheet1").Select
            Application.CutCopyMode = False
            Selection.AutoFilter
            Sheets("Sheet2").Select
            Range("A1").Select
            Application.ScreenUpdating = True
            On Error GoTo 0
        End Sub

         

        However, I have updated your workbook with this macro, and assign it to a button.

         

        Hope that helps

    • tube.designing's avatar
      tube.designing
      Copper Contributor
      Oct 21, 2018
      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

Resources