How would the macro determine where to go based on the letter and column
combination.

assume the cell in column E would correspond to the cell selected in one of
columns F to P

set rng = Intersect(columns(5),ActiveCell.EntireRow)
sLetter = rng.Value

Now what?

--
Regards,
Tom Ogilvy









I need a macro that sort of performs a lookup, based on first, the
letter I would input in col. E, and then second, the column that the
curser is in, (which could be any or all cols. from F - P) and then,
when i invoke it, displays a corresponding sheet that will contain a
table I will make that relates to that letter/column combo. I dont know
if it would be an If-Then type procedure or what, but is is certainly
beyond my capability to do. Please not that this letter/column scenario
is repeated on row after row in my spreadsheet, and not just one row.
Thank you very much,

Billy