I have the following code which i cycle through a bunch of checkboxes and if checkbox is true the row does not hide. When false it is hidden.
Dim c As Range
For Each c In Worksheets("Sheet1").Range("G6:G80")
If c.Value = "True" Then
c.EntireRow.Hidden = False
Else
c.EntireRow.Hidden = True
End If
Next c
The following is what i want to do. If the checkbox is true i also want the information from the cell to be copied into another sheet for example sheet2. If there is multiple checkboxes i want all the information to be copied into a cell from ecah checkbox selected and appended to each other. For example if i have 1234 in sheet 1 column/row G6 and then 5678 in column/row G7 i want the sheet 2 output to show all info in one cell for example Sheet 2 i would like to display the info of sheet one 1234 carriage return then 5678 carriage return ect.
any help would be appreciated
Bookmarks