teacher

  1. A

    Consolidating data from many sheets into one sheet

    Hello, I need help consolidating data from a workbook with 31 tabs (individual staff members). The tab reports seat times online for teachers. Below is a sample tab. The sheet columns are shown in blue. The rows beneath the headers can vary wildly by teacher. I run some code and get a number...
  2. A

    Macro for a large report

    Hello, I run a report which lists all 31 teachers on my staff and the number of lessons they have graded during a particular grading period. The format looks something like this(see below). What I have to do for each teacher is copy and post their grading information into another report. In the...
  3. A

    VBA Macro Problem

    Hello, I work for an online school and supervise 31 teachers. Twice a month, I run a report which gives me the number of hours each teacher has spent online. I output the report in an excel workbook. The output has 31 tabs for each teacher's information. The tabs are Sheet 1, Sheet 2, etc. I...
  4. D

    Teacher In Urgent Need of Help

    Hi everyone, Sorry, with vbna I am only at the search for what I want, find what I can alter and put the pieces together stage of vba i.e. quite a novice. Your help is MUCH appreciated as I am using excel to automatically update a form with every change of lesson to give links focus and time...
  5. C

    VBA Looping Presentation

    Dear Excel Wizards, I am currently a student taking my first class on visual basic. Our class's first project is to create a looping presentation using VBA. Basically, we need to write a code that uses the Loop until function. It is a very open ended question and it is open to creative minds...
  6. M

    Matching students to teachers based on set crteria

    I am looking to match students from the students table to teachers in the Teacher Table. The criteria is the following: A teach can only have one student Student should be matched with a teacher based on the following : Their preferred area in Column N with the Teacher Area in Column C...
  7. F

    VBA: Insert 2 columns if header matches

    I need to insert 2 columns if the header contains "*FFT Target". I've found this code, however, it does not move on to the next column containing "FFT Target" but inserts the two rows before the first column where the heading matched. Sheet headers I currently have are: <tbody> English FFT...
  8. A

    A macro to reset cells, starting a countdown timer and counting how many times another macro runs

    I have run into problems using macros to control some actions in the “Rainbow Fact Challenge” worksheet. https://www.dropbox.com/s/8moydblnshrfm08/Beat%20the%20clock_ver%202.0.0.xlsm?dl=0 I do not know how to code in vba. All my macros I have ever used are either recordings or cut and paste...
  9. LxQ

    Combine multiple records into one

    I would like to combine records into a query. For example, the table would be Jane, Doe, teacher, math Jane, Doe, teacher, English I would like the query to have: Jane, Doe, teacher, math English
  10. S

    Is it even POSSIBLE to get multiple outcome via vlookup?

    Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...
  11. S

    Is it even POSSIBLE to get multiple outcome via vlookup?

    Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...
  12. E

    Delete contents of highlighted cells

    Hi Folks I need some highlighted cells to be deleted. The background to the problem is as follows. Excel needs to compare two ranges (teachers, abbreviated) called Total_Range and Educators_Invig) and highlights (or somehow identify) the cells (teachers) in the dynamic range called Total_Range...
  13. P

    Concatenating a string in a "Many-to-One" relationship

    Hi all, Uploaded a pic of what I would like help in accomplishing: http://imgur.com/9j5n7LZ Column a have teacher name, column b have student name. Each student can have more than 1 teacher. For example, adam have all 3 teacher so I list their name Mr Robinson, ms Martinez, mr orwell...
  14. E

    Count and warn if number is exceeded

    Hi folks. I am setting up an invigilation roster in which an educator can only be assigned once per day per room. If you attempt to assign the educator again for the same day, then Excel needs warns you and delete your second assignment of the educator. I can do this for one day, and it works...
  15. M

    VBA Help: Transpose data from duplicate rows to new columns

    Hello! I have data that looks like this: <tbody> Name ID Position School Endorsement Joe 123 Teacher Stellar Elementary Endorsement 28 Joe 123 Teacher Stellar Elementary Endorsement 35 Joe 123 Teacher Stellar Elementary Endorsement 12 Jim 124 Custodian Thunder Middle Endorsement 25...
  16. E

    Cell Values within a Formula

    Hello! I am a teacher doing some data sheets for the upcoming school year. I am mainly self-taught and google solutions often, but can't get this to work. (I'm actually in Google Sheets so that admin can get live updates) Two different things, but wanting the same result: 1. I am doing a...
  17. H

    Question about forecasting payroll

    Hi all, I am trying to forecast hourly teachers salary for the rest of the year. This particular teacher works 32 hours per week, 45 weeks out of the year and paid hourly wage of $20/hour. How do I write a formula so that it calculates monthly salary for the whole year. This teacher does not...
  18. P

    Check value in the same cell of several worksheets - create timetable

    Hello, I keep spending lots of time trying to solve this problem, and altrough not there I have learn some Excel in the way ... but not enough, so I hope someone can help me out.. Here it goes: I have an Excel 2016 workbook with several worksheets with my School classes...
  19. T

    Error if more than 1 occurance

    Ok so I have a large grid. I have an index match formula that is searching for the teacher & period and returning the course. I want to include a "check" in the formula that shows an error if the same teacher is has their name more than once for the same period. My formula currently in...
  20. M

    Primary Teacher Needs Help please

    Hi I am hoping that someone can please help me. Our schools spends hours every year calculating how many students should go in each class. We are given teachers on the ratio of students to teachers. Unfortunately, the students never fall evenly in the classes so we have to put some students from...

Some videos you may like

This Week's Hot Topics

Top