+ Reply to Thread
Results 1 to 6 of 6

Open sheet of workbook as per the selection in drop down list

Hybrid View

Itisha Open sheet of workbook as per... 01-07-2015, 06:07 AM
samba_ravi Re: Open sheet of workbook as... 01-07-2015, 06:13 AM
Itisha Re: Open sheet of workbook as... 01-07-2015, 06:14 AM
samba_ravi Re: Open sheet of workbook as... 01-07-2015, 06:37 AM
Itisha Re: Open sheet of workbook as... 01-07-2015, 06:46 AM
samba_ravi Re: Open sheet of workbook as... 01-07-2015, 07:17 AM
  1. #1
    Registered User
    Join Date
    01-07-2015
    Location
    Hyderabad
    MS-Off Ver
    2010
    Posts
    4

    Open sheet of workbook as per the selection in drop down list

    I have created a data entry tool. If i click of drop down list of months so how it will open entry sheet of that particular month. I want to enter data of april'15 then select month "april'15" from drop down list and open entry sheet of april'15. How to do this

    Similarly IF I want to enter data of Junel'15 then select month "June'15" from drop down list and open entry sheet of "Data Entry June'15". How to do this
    Attached Files Attached Files
    Last edited by Itisha; 01-07-2015 at 06:20 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Open sheet of workbook as per the selection in drop down list

    Hi welcome to the forum
    Attach sample file
    you can do it with a macro
    Attach A File.jpg
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-07-2015
    Location
    Hyderabad
    MS-Off Ver
    2010
    Posts
    4

    Re: Open sheet of workbook as per the selection in drop down list

    Dear Siva

    Thanks for reply
    i have attached a file, please check

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Open sheet of workbook as per the selection in drop down list

    See the attached file
    Note
    Your Data sheet name should be "Data Entry "&April'15 (Month should be same as the month selected from Dropdown list
    for example September'15 Month the sheet name should be Data Entry September'15
    like the create your new sheets and modify the existing sheet names if any not matching as above

    in this case I Changed it for April'15
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-07-2015
    Location
    Hyderabad
    MS-Off Ver
    2010
    Posts
    4

    Re: Open sheet of workbook as per the selection in drop down list

    thankyou so much, but can you tell me in detail how you have done this, i am not able to understand.

    how you did that. please
    Last edited by Itisha; 01-07-2015 at 07:06 AM.

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Open sheet of workbook as per the selection in drop down list

    It works with macro (vba code)
    Open the excel File
    Press Alt+F11
    Micro Soft Visual Basic will open, there you can find the code

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-07-2014, 01:54 PM
  2. Replies: 5
    Last Post: 07-22-2014, 06:29 AM
  3. Replies: 0
    Last Post: 05-06-2013, 08:33 AM
  4. [SOLVED] Automatically open a different sheet within the workbook when a selection is made
    By clovelly in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-16-2012, 10:53 PM
  5. Replies: 3
    Last Post: 10-07-2005, 05:05 AM

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