LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Worsheet selection

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unprotect Worsheet ddm Excel Programming 0 August 19th 08 03:08 AM
worsheet evelyne Excel Discussion (Misc queries) 2 April 13th 07 11:29 PM
Worsheet and workbook tiler New Users to Excel 1 April 19th 06 01:22 PM
VBA for Consolidated Worsheet tahir Excel Programming 0 March 17th 06 08:35 PM
secure your worsheet using vba solo_razor[_34_] Excel Programming 1 November 17th 03 02:03 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"