+ Reply to Thread
Results 1 to 4 of 4

Automatically open a different sheet within the workbook when a selection is made

  1. #1
    Registered User
    Join Date
    01-24-2012
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    32

    Automatically open a different sheet within the workbook when a selection is made

    these are the instructions my workers will see when they open the program Sheet 1 - titled 'Instructions'

    indicate by placing an 'X' in the box which fuel type you are using


    Petrol

    Diesel

    ................................................................................................................................................
    this is what I want to happen, once a selection is made.


    If cell f5 is selected, automatically go to sheet titled 'petrol' cell A2
    If cell f7 is selected, automatically go to sheet titled 'Diesel' cell A2
    I do not want workers to be able to manually open the wrong page.

    I've tried a few ideas, but with no success. Any help would be appreciated.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Automatically open a different sheet within the workbook when a selection is made

    Hello clovelly,

    Try the attached WorkBook.

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Automatically open a different sheet within the workbook when a selection is made

    Hello clovelly,

    You are welcome.

    If you have any questions about getting it to work, just ask.

    Thank you for the Rep.

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2010
    Posts
    4,332

    Re: Automatically open a different sheet within the workbook when a selection is made

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
    For the meantime I'll do it for you.

    How?
    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

    Note:
    You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
    By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1