View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cesar cesar is offline
external usenet poster
 
Posts: 43
Default WorkSheet Change or select based on a cell value

Hi,

How can I change/select a worksheet based on a value of a cell?

I named a cell "GRADE" (let's say on my Sheet1) which is going to change
based on a user entry. This GRADE value is an alphanumeric value, if GRADE =
61026S select Sheet2, if GRADE = 61042 select Sheet2, and so on..

Thanks
--
Cesar