User Profile
mendthefabric
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Task List that transfers to Calendar
I am in college currently and am needing to be as organized as possible, in order to maintain my grades. I have very minimal knowledge of VBA, but I have created some. I will try my best to explain, if you are able to help that would be awesome! Task List, with Due Date, assignment, class, time due VBA already installed into task list worksheet Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 1 Then Dim lastRow As Long lastRow = Cells(Rows.Count, 1).End(xlUp).Row Range("$B:$D:A" & lastRow).Sort key1:=Range("A2:A" & lastRow), order1:=xlAscending, Header:=xlYes End If End Sub Calender with Drop Down that updates automatically What I Need Overall a task list that automatically sorts, as I enter new data, by the due date and highlights the whole row if it contains the class name (VBA that is already on that list) (already done) I need to take those assignments and enter them onto a monthly view calendar, same document but different sheets. i need the assignments entered to highlight in the color of the class, automatically if possible: as I enter data, automatically also enter and do all this code behind the scenes. I hope this made sense, let me know if you can help with that.
