I've got a workbook that performs a series of tasks, according to the Name of a department in a list of 12. Assume the Name of that department is on B1 and the list of departments is on a separate tab, rows 1-12.. Once the workbook refreshes its tasks, I'm going to have it save two tabs into a separate file. However, I'm having trouble with figuring out how to get a macro to repeat those tasks for each of those 12 departments until it hits a blank cell. Make sense? Any ideas?