Hello All,
I would like to create a loop within a public sub using the attached workbook. Would provide some VBA coding for the following scenario? The following is not really code, just parameters:
Sub Copy_and_Paste_of_Active_Cells_below_current_Selection
1. Go to Worksheet "Data Dumpster & Cruncher"
2. If entire rows have not already been selected, select Entire rows that are active starting with row 1 through the row before the next blank row (in the attached, that means rows 1 through 70).
2a. Or if entire rows HAVE been selected, go to the next series of rows that are active after the next blank row (in the attached, that means rows 72 through 149).
2a. If there are no more active rows below current selection, end macro with MsgBox "FINISHED!"
3. Run Macro "String_of_Macros_Strung_Together"
4. Run Macro "Copy_Time_Sheet"
5. Loop back to Step 1.
End Sub
Bookmarks