' Check if the song is marked as "rehearse" ' Loop through each song in the source range ' Clear the target sheet before copying the rehearse songs Set sourceRange = sourceSheet.Range("A2:A" & sourceSheet.Cells(, 1).End(xlUp).Row) ' Adjust the range as per your actual data structure ' Assuming the songs are listed in column A starting from row 2 ' Define the source range containing the songs Set targetSheet = ThisWorkbook.Sheets("TargetSheetName") Set sourceSheet = ThisWorkbook.Sheets("SourceSheetName") ' Set the source sheet (where the songs are listed) and the target sheet (where the rehearse songs will be copied)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |