Forum Discussion

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

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

  • 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
  • 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
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Oct 21, 2018

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



      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Oct 22, 2018
        one small detail... How did you create the checkboxes?
        thanks..
    • 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 22, 2018

        Thank you very much for your reply.

        But there is a problem: when i write nothing in column G ( notes) will not copy the names in coloum H.

        Because I said that sometimes i want to write a word in coloum G.

         

        after solving this problem please tell me how to continue coloums to the bottom of coloum because I need more than 1500 checkbox and names and notes in column G and H and I.

        Thanks again

Resources