Excel macro to find value with a condition [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I want the selection at "Recipe" cell at such a condition and proceed with further macro code those I already have. Is it possible?
Sharad

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
So are you only searching for this C1180230 (is this a concern number ? data look so familiar)
no, i would search for other such occurences. for now it appears to me that i need separate codes for different searches. this is one instance.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Sorry I was not clear earlier. What I wanted to know was how this number is picked to be searched etc. You need to provide some sample data and explain how you want

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!