teacher

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...