II have one profit and loss statement template in excel that is populating
information from an excel data worksheet using vlookup formulas. Is there a
way to create a macro that will select each dept number print the income
statement and go to the next dept number and print the income statement for
that department?

Basically I have a list of twenty department numbers and each department
number is unique. The macro should select each department number to populate
the profit and loss template, print that information and go to the number
department.
..