I have an excel template that imports information from a datasheet using
vlookup formulas. I want to create a macro that first selects a department
number from a deparment list to population the excel template and print the
worksheet, then selects the next deparment populates the template print, etc.

Rick