+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

Macro to add new 'teacher'

  1. #1
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Macro to add new 'teacher'

    Hey all,

    I am currently in the process of voluntarily making a spreadsheet for an education centre. I have produced most of it, but I want to also make a system where I don't need to administer it. In other words, be able to be used by someone with limited Excel skills.

    The spreadsheet tracks both student numbers (1st sheet) and how many students each teacher teaches (2nd sheet). Week-to-week data can easily be inputted, but I'm struggling to find a way how to solve less often events. For example, a teacher leaves or a new one arrives.

    I'm sure Macros can help with this, but I'm not quite sure what to do from here. I'd like to press a button and then a new column arrives and formulas from the left of it are duplicated. From here, the 'user' only needs to input a name and some data.

    Happy to answer any questions if I haven't explained the situation very well.

    Thanks,
    Ryan

    Attached below is the spreadsheet.

    Real English Student:Teacher Tracker (Gaoming Branch).xlsx

  2. #2
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: HELP: Macro to add new 'teacher'

    Anyone can help?

  3. #3
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Macro to add new 'teacher'

    Anyone can help?

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    3,483

    Re: Macro to add new 'teacher'

    I'm sure Macros can help
    Yes certainly but can you give more details

    a new column arrives and formulas from the left of it are duplicated
    Which columns, formulas ...
    How you will do it maually ?
    - Battle without fear gives no glory - Just try

  5. #5
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22
    ‘NEW’ and ‘LEAVE’ are for users to input date, the rest have formulas (apart from Week 1, Week 1 requires the user to input the ‘TOTAL’)

    Does this help?
    Last edited by AliGW; 12-06-2018 at 04:35 AM. Reason: Quotation removed - not needed.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,944

    Re: Macro to add new 'teacher'

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  7. #7
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22
    Sorry, Iím using my phone at the moment and I couldnít see that button.

  8. #8
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    3,483

    Re: Macro to add new 'teacher'

    Can you give very detailed explanations where to add data.
    In sheet "Teacher Tracker"
    is it in column "O" ???
    Where to copy/paste formulas ?? is it for all rows ,
    while there is not formulas in all of them ... what to do ?
    Is it for all weeks ? Does it make sense to do it before the active week: Today we are week 49
    in sheet "Student Tracker" don't we need to add a row for the new teacher ???

  9. #9
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Macro to add new 'teacher'

    Sorry for the long delay, and thanks for getting back to me! Since our last contact, the design of the sheet has been simplified (all weeks are chronologically listed from Week 1 to 22).

    Quote Originally Posted by PCI View Post
    Can you give very detailed explanations where to add data.
    In sheet "Teacher Tracker"
    Copy and paste cell values in "TT" and add new row in "ST".

    Quote Originally Posted by PCI View Post
    Where to copy/paste formulas ?? is it for all rows ,
    while there is not formulas in all of them ... what to do ?
    Copy and paste all formula from left column. As you mentioned, some cells don't have formulas, with these just leave blank.

    Quote Originally Posted by PCI View Post
    Is it for all weeks ?
    Yes.

    Quote Originally Posted by PCI View Post
    in sheet "Student Tracker" don't we need to add a row for the new teacher ???
    Yes, the macro should also create a new row in the "ST".

    Thanks PCI.

    P.S. Attached below is the new, slightly more simplified spreadsheet.

    Real English Student Teacher Tracker (Gaoming Branch) 1.xlsm
    Last edited by heyryy; 12-20-2018 at 09:55 AM.

  10. #10
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Macro to add new 'teacher'

    Can anyone help?

  11. #11
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    3,483

    Re: Macro to add new 'teacher'

    In sheet "Teacher Tracker" in the last sample file records for "NAM" is not complete !!!
    Is there a reason ???

  12. #12
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    3,483

    Re: Macro to add new 'teacher'

    Is it what you want
    Please Login or Register  to view this content.

  13. #13
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Macro to add new 'teacher'

    Perfect! Is there a way to create a macro that can remove a teacher also?

    Thanks

  14. #14
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    3,483

    Re: Macro to add new 'teacher'

    Something like next code ???
    Please Login or Register  to view this content.

  15. #15
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Macro to add new 'teacher'

    Again, perfect.

    One last thing I promise! All cells that contain formulas will be protected, and so, the macro returns a Run time error. I've tried a few different types of code to unprotect and re-protect the workbook, but I haven't been successful yet?

    Any ideas?

    Ryan

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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