Can anyone give advice on how to accomplish the following:

I need a print macro in excel where I have two drop down list the
first one being "defined" as "category" & the second being "defined"
as "consunit." The category & the consunit dropdown lists are built
off of a list on a new sheet labeled "date information". What I need
is when i click on the print macro, it will go to Category & read the
first item in the drop down, then read the first item in the consunit
dropdown & print. Then I want it to stay on the first item in the
Category drop-down & pick the second item in the consunit drop-down &
print. Once it finishes scrolling through all of the consunits, it
should then go to the next item in the category list & the print each
item again in the consunit drop-down. Then the third item in the
category list & all items listed in the consunit dropdown. (take the
1st item from List A, & print this item with each of the items in the
List B, then pick the 2nd item from List A & cycle again through all
the items of List B, & so forth.