Zuid-Holland
06-27-2005, 11:29 AM
Dear All,
I am the first timer for excel-vba and am entrusted with this huge diffi task of uploading thousands of rows of validated data through the excel templates. Performance (macro-validation-performance) is a key issue.
The end-user uploads the data something like:
"ID, Tier, Type, Name, etc etc". There are validations like the ID should be unique, if Tier is some value-then Type cannot be certain value(s) and the like, to present to you with a clear picture. I want to know:
"How to identify the duplicate entries in the column, get the cell-reference of those errors and write that on a separate error-sheet for the user, so that he knows where all he has provided wrong data. The user may enter data, copy data or etc. Also, since the performance is a key issue, reading a row - making a range on that col - looking for same value is not a good idea."
I would really be obliged to anyone who could help me out with this and also with some pointers, if possible.
I really appreciate your taking time and thanks a million!!
Regards.
I am the first timer for excel-vba and am entrusted with this huge diffi task of uploading thousands of rows of validated data through the excel templates. Performance (macro-validation-performance) is a key issue.
The end-user uploads the data something like:
"ID, Tier, Type, Name, etc etc". There are validations like the ID should be unique, if Tier is some value-then Type cannot be certain value(s) and the like, to present to you with a clear picture. I want to know:
"How to identify the duplicate entries in the column, get the cell-reference of those errors and write that on a separate error-sheet for the user, so that he knows where all he has provided wrong data. The user may enter data, copy data or etc. Also, since the performance is a key issue, reading a row - making a range on that col - looking for same value is not a good idea."
I would really be obliged to anyone who could help me out with this and also with some pointers, if possible.
I really appreciate your taking time and thanks a million!!
Regards.