ok, im going to apoligize in advance for the length of this post, but i rather give too much info than not enough.

i should start off by saying that i would consider myself rather advanced with formula editing, but very inexperienced with macros.

i have a worksheet that has a data validation list in it, and i want to write a macro that will select the next new value in that list. for example, if i have a list like this (and yes, it will be in alphabetical order):

apple
banana
banana
grape
orange
orange
orange
peach

and the current selection is banana, i want it to automatically find the next new value, so even if it has the first banana selected, i want it to move to grape.

the overall goal of this macro will be to:
select the next in the list,
the rest of the spreadsheet will automatically update based on the formulas,
then it will hide certain rows of the worksheet based on given values,
print the sheet,
unhide all rows,
select next value and repeat until it reaches the end of the list.


the print statement will look something like this:
Sheets("Statement").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
unhide will be:
    Cells.Select
    Selection.EntireRow.Hidden = False
so essentially, what i need help with is the selecting next in the list, then i will need to be able to hide a row based on whether or not the sum of columns e through i are greater than $10 in a given row, but im pretty sure i could figure out the hide statement.

thanks in advance for the help, and you guys have helped me more than you know just by searching through the forums.
-Ryan