I created a workbook with multiple time cards (1 for each employee on different sheets). I need a vba code to copy and paste from each sheet into a compiled master sheet ("Data") The first line of data in each timecard sheet is in B8:H8. Some timecards could have a variable amount of lines from blank to 20 different lines of entry. If they are blank I need the code to skip that worksheet. The data needs to be pasted in the first empty row at the bottom of sheet ("Data"). Ideally I would like the code to do a cut and paste so the timecards are left blank once I run they code.
Each sheet with a time card ends in "_TC" so the code can include a variable to shorten it ...something like this
For Each Ws In Worksheets
If Ws.Name Like "*_TC" Then
Each sheet with a time card ends in "_TC" so the code can include a variable to shorten it ...something like this
For Each Ws In Worksheets
If Ws.Name Like "*_TC" Then