Filtering

[codyryan]

Hi I am looking for some help, but am not sure I can explain exactly what I want so I will try my best!

In this spreadsheet:
Copy of Homework Tracker.xlsx
I will be tracking homework, but my problem is that it is for five different classes (the classes are called M1, G1, G2, E1 and E2 as in column C) so I am struggling to work out how I can make different data appear when filling in data for one particular class. So for example if TEACHER A wants to input the title of their homework for class G2 into cell D1 it means that another teacher would have to put their title in cell H1 so as not to overwrite it. Is there a way to still keep all the data to one column at a time, but at the same time being able to add different titles and due dates?

I hope I have been clear, but suspect I may have been as clear as mud!

Thank you

[FDibbins]

Why not just keep adding data to the bottom of the list? They enter a name, something in B, the class and the % mark. the next 1 enters the same info in teh next row down, and so on?

Perhaps if you included some sample data, and what your expected answers would look like?

[codyryan]

I think what I want is some kind of dropdown menu where the teacher can choose their class then input the marks, title, due date etc. I only know how to filter one set of data in one column (as I have done in column C)

[FDibbins]

Dropdown menus (Data validation) are relatively easy to set up.

1. create a list of all classes
2. give that list a range name (I used Class)
(this step is not essential, I just feel it makes things easier to manage)
3. click on teh cell wherre you waht the DropDown
4. click Data Tab/Data validation
5. Click Allow and Select List, in Source enter =Class

[codyryan]

Sorry I don't think I have explained myself very well.

I am looking for a way that all teachers can enter their homework title into D1 depending on the class they teach then enter their marks for that particular title and class into D5:D118.

Or a dropdown where they choose just their class ( class G2 for example) and only data for their class appears and they can enter the homework title and marks etc

[FDibbins]

so you want everybody to enter into that specific cell - D1 - each time?

[codyryan]

Either that, or a dropdown list where each teacher can choose their class and only the data for their class will show up

[FDibbins]

Show me what you want please (in your file), I cant picture it

[codyryan]

It's really difficult to explain. My problem is that there are three teachers teaching five classes and we all need to put our homework marks into column D, but each of our homework titles and due dates will be different so if I set homework called "grammar test" and it is out of 20 and due on 15th September for example, and enter that information into D2, D3 and D4 then the other teachers have nowhere to put the information for the homework that they set.

I know one option is that I could have one sheet per class, but I have done it this way before and it proved to be a bit of a pain so was hoping to have each year group on one sheet.