Forum Discussion
Copy and paste checkable text
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
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
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
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
Hi,
I tested it again and it works!
But I guess that you didn't select any name!
It only copies the selected names that have TRUE values.
Please note that the macro is programmed to take into account the new records.
Therefore, if you added a new record, and select it, it will be copied it to the new sheet.
Do you want to automate the task of adding and linking the new checkboxes?
Regards
- Thank you fir your reply.
Sometimes i wamt to write nothing in Notes!
For instance I want to select Dave but i delete 10.
Now i expect to copy Dave without 10.
For questions number 2 the my answer is yes. I want to automate the task of adding and linking the new checkboxes.