Auto value selection from list of values based on conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2067458%22%20slang%3D%22en-US%22%3EAuto%20value%20selection%20from%20list%20of%20values%20based%20on%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067458%22%20slang%3D%22en-US%22%3EHi%20all%2C%20I%20need%20your%20help.%3CBR%20%2F%3EI%20have%20a%20list%20of%20values%20(codes)%20on%20one%20sheet%20in%20excel%2C%20i%20need%20to%20create%20on%20other%20list%20generator%20of%20this%20codes%20based%20on%20some%20conditions%20and%20after%20the%20generator%20show%20availeble%20code%2C%20this%20code%20will%20have%20%E2%80%9Cused%E2%80%9D%20status%20on%20other%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20some%20voucher%20codes%20and%20I%20need%20to%20automaticaly%20generete%20the%20available%20code%20and%20set%20the%20status%20of%20this%20code%20as%20used.%3CBR%20%2F%3EIn%20excel%20for%20web%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20you%20help!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2067458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2068809%22%20slang%3D%22de-DE%22%3ESubject%3A%20Auto%20value%20selection%20from%20list%20of%20values%20based%20on%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2068809%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931645%22%20target%3D%22_blank%22%3E%40JakubBanda%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%3C%2FP%3E%3CP%3EEven%20if%20I%20may%20not%20be%20the%20right%20one%20to%20give%20you%20an%20answer%20(...%20or%20maybe%20I%20am).%3C%2FP%3E%3CP%3EI%20would%20like%20to%20give%20you%20some%20advice%2C%20with%20your%20permission%2C%20for%20this%20forum.%3C%2FP%3E%3CP%3EAlways%20add%20an%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20S%3C%2FP%3E%3CP%3Eo%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowledge%20of%20the%20exact%20name%20of%20the%20Excel%20version%20(example%3A%20Pro%20or%20Pro%20Pus%2C%20Web%2C%20etc.)%20and%20the%20operating%20system%20(example%3A%20Win%2010%20-2004%2C%20Win%2010%2020H2)%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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)

@Nikolino 

 

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

 

J.