I have multiple sheets from which I would like to copy information from to one general sheet (sheet 1). To let Excel know whether it has to copy the information, I decided to use an extra column in those sheets with the criteria to return a "true" value.
Now I have read some other threads and this is a macro that I have started trying to adapt to my specific situation but somehow I keep failing.
- b is each time the column in my multiple sheets that returns the true or false value. The information in the row matching the true value should be copied to Sheet1
- "S37" is the name of one of my sheets from which I would need to copy information from. I would still need to adjust it to multiple sheets.
- Excel gives me an array error message with this code
Private Sub CommandButton21_Click() Sheets("S37").Select RowCount = Cells(Cells.Rows.Count, "b").End(xlUp).Row For I = 1 To RowCount Range("b" & I).Select check_value = ActiveCell If check_value = "True" Or check_value = "true" Then ActiveCell.EntireRow.Copy Sheets("Scorecard").Select RowCount = Cells(Cells.Rows.Count, "c").End(xlUp).Row Range("b" & RowCount + 1).Select ActiveSheet.Paste Sheets("S37").Select End If Next End Sub
I greatly appreciate any help!