I have an Excel spreadsheet that contains two sheets.Suppose the names are sheet1
and sheet2
.
There are several data in column A in sheet1
and several data in column A in sheet2
.
How can I restrict users when they enter data to avoid to enter duplicates of data in both sheets that is already available in column A sheet1
and column A sheet2
?
That means new entries must be unique and they cannot match with anything on column A of sheet1
and column A of sheet2
.