+ Reply to Thread
Results 1 to 16 of 16

Macro to add new 'teacher'

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

    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 2020
    Posts
    26

    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 2020
    Posts
    26

    Re: Macro to add new 'teacher'

    Anyone can help?

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    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 2020
    Posts
    26
    ‘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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,362

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    04-19-2015
    Location
    Durham
    MS-Off Ver
    Excel 2020
    Posts
    26
    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
    MS 365 Office Suite
    Posts
    5,066

    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 2020
    Posts
    26

    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 2020
    Posts
    26

    Re: Macro to add new 'teacher'

    Can anyone help?

  11. #11
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    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
    MS 365 Office Suite
    Posts
    5,066

    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 2020
    Posts
    26

    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
    MS 365 Office Suite
    Posts
    5,066

    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 2020
    Posts
    26

    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

  16. #16
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro to add new 'teacher'

    Any ideas?
    There is a lot threads about this topic have a look or open a new one.

+ 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. Macro to select lesson price based on teacher and length of lesson
    By ZzanderzZ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2017, 08:09 PM
  2. Macro to copy rows by date for a teacher audit
    By Bpd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2013, 11:08 AM
  3. new teacher
    By jumpingjack in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-15-2013, 12:44 PM
  4. teacher in need of help.
    By tonysix00 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2013, 03:16 AM
  5. Please help this teacher out
    By NoProgram in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2006, 02:45 AM
  6. School teacher
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  7. School teacher
    By yeahbaby in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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