semester

I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage. When a user double clicks a term in column B a multipage in a userform pops up. So if Semester 1 is double clicked the...

Long story short I'm still about one years old using VBA and I'm making a spreadsheet with multiple semesters in column A. In column B is tuition, and in column C is fees. I just started making this so I haven't gotten very far, but I currently have it set up where when you click on cell C1 a...

Hi, This appeared to be a simple vlookup and match task but I kind of ran into a roadblock. I'm working on a financial report that shows amounts of aid students will receive for the year and semester. In sheet 1, I have a list of students that are coded with a unique ID number and an item type...

Hi, I'm working on a personal file to handle my insurance portfolio and I need to identify which ones have to pay depending on what they bought ( By trimester,semester or yearly). The tricky part is that the start date has to remain the same. i.e. Start date : Nov 1st 2017 Type: Trimester...

Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...

I have some course data that has grade distributions. I would like to extract this data based on the course name and the semester when the course was taught. Is there a way to loop through a list of courses by semester, and lookup the grade data? In other words, start with ACC1013 and lookup...

Hi guys. I am a teacher working on a spreadsheet that requires the extraction of data separately for fall & spring semester. My dates are done in columns so that each row is a student. Please see me cheesy example below: 8/17/2017 12/19/2017 1/3/2018...

Hi there, I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade...