david gabra
Member
Hi
I really would appreciate if someone can help me. I'm sure there much be a smart solution, I'm just not start enough to know it :-(.
I have 2 files one for the month of May and one for the month June, and I would like to know if there are any differences between the two files. The manner and format of the files make is impossible for me to do this without hours/day of manual manipulation. I am hoping someone can come up and show me an inspired way to do this.
I have attached the two files so you can clearly see what I need.
In column A - you have the employee number, and we are comparing for each employee.
In Row 13 you have the different codes we want to compare.
For each code, an employee may or may not have a value.
I want to see if there were any changes in the June to May file per employee for each of these codes.
I would like to take the sheet tab called 'June' and create two new columns after each code, and in 1st new column to add the data the relates to the employee in the prior month (sheet tab 'May')for the same code, and in the second new column to add a text field (either "same or "different").
The codes start from column D
Please remember I want to compare June to May.
I hope I have explained myself clearly.
Thank you *1000000 for anyone that can help.
David.
I really would appreciate if someone can help me. I'm sure there much be a smart solution, I'm just not start enough to know it :-(.
I have 2 files one for the month of May and one for the month June, and I would like to know if there are any differences between the two files. The manner and format of the files make is impossible for me to do this without hours/day of manual manipulation. I am hoping someone can come up and show me an inspired way to do this.
I have attached the two files so you can clearly see what I need.
In column A - you have the employee number, and we are comparing for each employee.
In Row 13 you have the different codes we want to compare.
For each code, an employee may or may not have a value.
I want to see if there were any changes in the June to May file per employee for each of these codes.
I would like to take the sheet tab called 'June' and create two new columns after each code, and in 1st new column to add the data the relates to the employee in the prior month (sheet tab 'May')for the same code, and in the second new column to add a text field (either "same or "different").
The codes start from column D
Please remember I want to compare June to May.
I hope I have explained myself clearly.
Thank you *1000000 for anyone that can help.
David.