Auto value selection from list of values based on conditions

Copper Contributor
Hi all, I need your help.
I have a list of values (codes) on one sheet in excel, i need to create on other list generator of this codes based on some conditions and after the generator show availeble code, this code will have “used” status on other sheet.

I have some voucher codes and I need to automaticaly generete the available code and set the status of this code as used.
In excel for web

Thanks for you help!
2 Replies

@JakubBanda 

With your permission, if I can recommend you,

Even if I may not be the right one to give you an answer (... or maybe I am).

I would like to give you some advice, with your permission, for this forum.

Add always a MS Excel file (without sensitive data) to your project.

Explain your plans in relation to this file. S

o you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowledge of the exact name of the Excel version (example: Pro or Pro Pus, Web, etc.) and the operating system (example: Win 10 -2004, Win 10 20H2) would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

 

Thanks for advice. I solved this. I create macro and it works perfectly. Next time i do as you said. 

 

J.