nether
01-11-2006, 05:34 AM
Hi all,
Let me quickly explain the problem. I have a workbook with 3 sheets in it. In the first sheet (sheet1), there are a couple of columns. In the first column there is a employee id.
On the 3rd sheet (sheet3), i have 2 columns. In the first column there is also the employee id, and in the second column there is the employee name.
Now, what i want to do is to compare the employee id from the first sheet with the employee id from the 3rd sheet. This can be done by application.match . However, if i do that, it says it doesn't find the employee id in the 3rd sheet.
If i fysically check the 3rd sheet, the employee id actually exist. :banghead: :banghead: :banghead:
Does anybody have a clue? :dunno I have attached the workbook as an attachment. Hope you can find the glitch.
Regards,
Rolf
Let me quickly explain the problem. I have a workbook with 3 sheets in it. In the first sheet (sheet1), there are a couple of columns. In the first column there is a employee id.
On the 3rd sheet (sheet3), i have 2 columns. In the first column there is also the employee id, and in the second column there is the employee name.
Now, what i want to do is to compare the employee id from the first sheet with the employee id from the 3rd sheet. This can be done by application.match . However, if i do that, it says it doesn't find the employee id in the 3rd sheet.
If i fysically check the 3rd sheet, the employee id actually exist. :banghead: :banghead: :banghead:
Does anybody have a clue? :dunno I have attached the workbook as an attachment. Hope you can find the glitch.
Regards,
Rolf