Hi,

As of now i use only one excel wich contains >5000 rows with IF condition.
Hence the time taken to enter a value and save the file is very long.

So, i thought of considering the file now am using as the database and will create a new file in which i use daily file.
what i want now is i need to compare the ref # of the new file with the old database and highlight if duplicated in the duplicate column of both the files with the count.

At the end of the day i have to apend the new file with the status "completed" to the old database.

Am doing this process to avoid duplicate processing.

Am not sure whether this can be done..
Any other idea will also be much appreciated..


Hope i made clear now..

-Sindhuja