hello all,
I need some help to make a sheet which have a column of agent names and other for their working currencies, agents do work in multiple currencies. here i need to ensure data sets(Agent Name + Currency) be validated only once in the sheet. in case of duplicate set, it should revoke entry and popup a msg box.
Moreover, for temp working i have tried to do it through helping column, but i need to replace it with some vba code. there are also some vlookups through that helping column, which also need to be replaced with vba code.
looking for your kind help. attaching the working file in the post
Bookmarks