G
Guest
Guest
Hi
I have a workbook with 50 sheets. About 40 sheets are edited three times each day (over 24hrs that is) and then printed out. As each sheet is edited the character "M" is placed in cell B2 for filtering in a mail merge. The present method is to select the edited sheets grouping them with Ctrl, for the printouts. The 40 sheets vary each day and the editing is done when the info becomes available, so the sequence in stepping through the sheets is never the same. We would like to include in the macro, which also does other tasks, a loop which examines each sheet for the character "M" grouping these sheets and then printout. Anyone an idea on a loop to do this ?
Eugene Robinson
Rhos on Sea, Wales
I have a workbook with 50 sheets. About 40 sheets are edited three times each day (over 24hrs that is) and then printed out. As each sheet is edited the character "M" is placed in cell B2 for filtering in a mail merge. The present method is to select the edited sheets grouping them with Ctrl, for the printouts. The 40 sheets vary each day and the editing is done when the info becomes available, so the sequence in stepping through the sheets is never the same. We would like to include in the macro, which also does other tasks, a loop which examines each sheet for the character "M" grouping these sheets and then printout. Anyone an idea on a loop to do this ?
Eugene Robinson
Rhos on Sea, Wales