I have 2 worksheets, A and B, and there is a cell "b2" that contains a
drop down list of division names (used data validation list). When each
different name on this drop down list is selected the 2 worksheets
change to show the results of this specific division. I would like to
make a macro that prints these 2 sheets for all the names on this drop
down list.

Please help

Thanks