You've gotten several replies to your previous thread. But the requirements
keep changing. You had some responses where the sheet names weren't the same as
the value you typed into the cell.

And you had some responses where the value typed in was the same as name of the
sheet to go to.

I don't understand one of those responses didn't help.

Cesar wrote:

How can I select worksheets based on the value of a cell? The value in this
cell is alphanumeric. Let's say in Sheet1 I have a cell named GRADE and the
value on this cell could be 61026H, 61042, 69026S, etc. if the GRADE value is
61026H select Sheet2, if it is 61042 select, Sheet3, etc. But if, let's say
the GRADE is 61042 the selected Sheet would it be Sheet3 and then the GRADE
value change on Sheet1 to 61026H we should select Sheet2.

Thanks for the help
Cesar

--

Dave Peterson