hi,

I have attahed the sample spreadsheet for your reference.
Reference number duplication to be found out.

Daily we will append the rows to the existing rows.
Is there a way to maintain a master database stored somewhere and when datas are updated in a daily workbook then the reference number in the daily workbook to be compared with the reference number of master database and highlighted if duplicated in daily workbook...

At the end of the day all the rows with status complted to be appended to the master database.


Can this be done using macros...

-sindhuja