Hello all,
I was wondering if I can get some input/advice on how to proceed with the project that I am currently tasked with.
Attached is just a rough template of what I envision the finished product would look like.
I would like to create an Excel file that:
1) Allows me to use my drop down menu in the "Input" spreadsheet to select a student, and either "approve" or "reject" a specific student's request for a course.
2) Once I either click "approve" or "reject", Excel will automatically populate my decision into the corresponding spreadsheet of "math", "science", etc.
3) The first time I reject a student, it will correspond to a specific color (as indicated in the "math" or "science" spreadsheet). There will be three different colors I use to quickly assist me in determining how many times I have rejected a specific student's request for a course.
4) I suppose that using the Macro, Excel will need to determine IF this is the first time I reject the student, it will return a specific color. IF I have rejected the student for a second time, it will return another color, etc.
Moreover, I will need the Macro to understand that IF a specific student (ex. John SMITH) is already in a certain spreadsheet (ex. Math), it will recognize that and instead of inserting a new row, it will merely add the corresponding color to him.
IF the student is not on a certain spreadsheet, Macro will simply add him into it in a new row.
Is this possible? In my mind, it doesn't seem too complicated but there are a lot of IF statements that may complicate things/possibly make this project not possible.
Thank you.
Bookmarks