I have a table in excel in which data like serial number and date are registered and after that, a button is pressed to send them to another tab to make a database. What I would like to do is to prevent the user of entering a duplicated value.
The "Concatenate" column was made because the "part #" is changed, so there can be serial numbers repeated, but of different part #. What I want to do is to make a macro that checks in the "Database" sheet (column 3 is where concatenate values are stored) if the value is already there, and if it is repeated, send a message to the user and not allowing him to insert that value.
Note:Concatenate values are made with formula =concatenate(serial number,part #), so I can't apply data validation since the user is not typing the cell value and its a calculated formula.
<tbody>
</tbody>
The "Concatenate" column was made because the "part #" is changed, so there can be serial numbers repeated, but of different part #. What I want to do is to make a macro that checks in the "Database" sheet (column 3 is where concatenate values are stored) if the value is already there, and if it is repeated, send a message to the user and not allowing him to insert that value.
Note:Concatenate values are made with formula =concatenate(serial number,part #), so I can't apply data validation since the user is not typing the cell value and its a calculated formula.
# | Serial Number | Date | Part # | Description | Employee | Concatenate |
1 | 10 | may 22 | 1234 | 101234 | ||
2 | 11 | may 22 | 1234 | 111234 | ||
3 | 12 | may 22 | 1234 | 121234 | ||
4 | 13 | may 22 | 1234 | 131234 | ||
5 | 14 | may 22 | 1234 | 141234 | ||
6 | 15 | may 22 | 1234 | 151234 | ||
7 | 16 | may 22 | 1234 | 161234 | ||
8 | 17 | may 22 | 1234 | 171234 | ||
9 | 18 | may 22 | 1234 | 181234 | ||
10 | 19 | may 22 | 1234 | 191234 | ||
11 | 20 | may 22 | 1234 | 201234 | ||
12 | 21 | may 22 | 1234 | 211234 |
<tbody>
</tbody>