Hi all,
I use a list where people add data in.
In column A from the worksheet "data" they add a code.
I would like that excel checks if that code exists in a range of existing codes that is on the sheet "products) in column A.
If it's a "new" code i would like to open a userform.
Anyone knows how i should do that?
I use a list where people add data in.
In column A from the worksheet "data" they add a code.
I would like that excel checks if that code exists in a range of existing codes that is on the sheet "products) in column A.
If it's a "new" code i would like to open a userform.
Anyone knows how i should do that?