+ Reply to Thread
Results 1 to 8 of 8

Interlinking Worksheets Via Macro's

  1. #1
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Interlinking Worksheets Via Macro's

    To Understand what i am trying to do it's better if you download the excel sheet.

    When you open the excel sheet you are greeted with the "Select Student" screen.
    The first Button Year 2 Marking is working.
    What i would like to happen next is the "GO" button looks into drop down box and see a name such as "John Smith" and then takes the user to the John Smith worksheet. And underneath is an Add Student what i was wondering is if that every time you Type a Students name then press Add if it's possible if every time it does that it will make a new worksheet in the same template as the John Smith Worksheet but with the students name as the worksheet title and where it says John Smith on the worksheet.
    Attached Files Attached Files
    Last edited by RPickering2; 01-19-2011 at 05:21 PM.

  2. #2
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Interlinking Worksheets Via Macro's

    Anyone help me? Can this actually be achieved within excel?

  3. #3
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Interlinking Worksheets Via Macro's

    Is anyone going to help?

  4. #4
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Interlinking Worksheets Via Macro's

    Need Help anyone please.

  5. #5
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Interlinking Worksheets Via Macro's

    Could anyone tell me if this is possible.

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Interlinking Worksheets Via Macro's

    Try the attached.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  7. #7
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Interlinking Worksheets Via Macro's

    Thank you so much I was struggling for ages. I can now study your code and learn thank-you.

  8. #8
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Interlinking Worksheets Via Macro's

    Hi RPickering2
    Should you need the code annotated, let me know.
    John

+ 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