shekhar_pc
Board Regular
- Joined
- Jan 29, 2006
- Messages
- 185
I have four files "EMPLOYEE A" "EMPLOYEE B" "EMPLOYEE C" AND "EMPLOYEE D" and a master file "MasterJun07"
I want to compare the numbers of each file with the master file.
For instance:
In the file "EMPLOYEE A.XLS", on 1st Jun, the numbers are 456 and 457, on 2nd june the numbers are 457 376 and 376 and if you see the master file for Employee A (in 3rd row) on 1st june, we have 456/457 and on second we have 457/376 376 that means the data is correct.
I want to re-check each and every record of the master file in each and every file. This is a tedious job that I have to do thrice a month for 250+ employees manually. Any help would be appreciated.
We just have to check the rows where there is an employee. Blank cells and cells with contents "JR" and "SR" should be ignored.
I am posting the files in my next post. In the example given, only 3rd 6th 9th and 14th row in the Master file needs to be checked.
For every employee name in the master file, there will be a different file name with the same employee name in the folder.
All files are kept in the folder "C:\data"
If there is a discrepancy, between the data mentioned in the master file and the one given in the employee file, the background cell color of the master file should change to red and font color to white and the cell address of the incorrect data should be copied into "Error" sheet in the master file to track the mistakes.
The data what I provided is a sample data. In real, I have 250+ files and the data that needs to be checked is for the entire month till 30th or 31st
I want to compare the numbers of each file with the master file.
For instance:
In the file "EMPLOYEE A.XLS", on 1st Jun, the numbers are 456 and 457, on 2nd june the numbers are 457 376 and 376 and if you see the master file for Employee A (in 3rd row) on 1st june, we have 456/457 and on second we have 457/376 376 that means the data is correct.
I want to re-check each and every record of the master file in each and every file. This is a tedious job that I have to do thrice a month for 250+ employees manually. Any help would be appreciated.
We just have to check the rows where there is an employee. Blank cells and cells with contents "JR" and "SR" should be ignored.
I am posting the files in my next post. In the example given, only 3rd 6th 9th and 14th row in the Master file needs to be checked.
For every employee name in the master file, there will be a different file name with the same employee name in the folder.
All files are kept in the folder "C:\data"
If there is a discrepancy, between the data mentioned in the master file and the one given in the employee file, the background cell color of the master file should change to red and font color to white and the cell address of the incorrect data should be copied into "Error" sheet in the master file to track the mistakes.
The data what I provided is a sample data. In real, I have 250+ files and the data that needs to be checked is for the entire month till 30th or 31st