compare sheets

Hello guys, I picked some extra classes this semester and am now trying to create a weekly schedule of my classes. At first I made a table with all activities from my classes, but I noticed some overlaps. I have some kind of ranking system where I put colors near the class (as you can see in...

I have been reading various posts on comparing sheets, and I am pretty close to my solution. Just need a little bit of help on the "compare and copy over to new sheet". I have two sheets (Summary) and (Tutor Attendance). Problem 1: I am trying to copy the monthly Summary totals to the...

Hello, I am using the following code that I found on another forum to compare two data sheets. Whenever I run the code though, it comes up with an error message "Run-time Error: 13 Type: Mismatch" for the line that is highlighted and underlined. It will highlight the differences in Excel, but...

The following code provides the srot of thing i am looking for However, this is comparing cell by cell, and where certain items are removed/added on the newer list it knocks everything out. Sub RunCompare() Call compareSheets("A", "B") End Sub Sub compareSheets(shtBefore As String, shtAfter...

Hi, I have two sheets in a workbook. Sheet1 includes information on average monthly pocket money of students from different schools. Sheet1: <tbody> Month School1 School2 School3 School4 Jan 100 125 125 100 Feb 125 100 75 125 Mar 75 150 100 75 Apr 100 100 125 100 May 90 125 100 125...

Hi everyone, I am trying to code a macro that would allow me to compare infomation in two separate workbooks and create a third workbook with the exceptions listed. A few things to note: 1) The information is in the form of a data tape in the speadsheet one file. 2) All differences with be...