Excel macro to find value with a condition

Closed

Sharad - May 31, 2010 at 06:39 AM
rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

- May 31, 2010 at 07:25 AM

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

Excel macro to find value with a condition
Excel macro to merge cells based on condition ✓ - Forum - Excel
Short cut to merge cells ✓ - Forum - Excel
Excel macro copy data from one sheet to another if a condition is met ✓ - Forum - Excel
How to copy a data from one sheet to another, when specific criteria is met - Forum - Excel
Excel macro to create new sheet based on value in cells - Guide

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
May 31, 2010 at 06:50 AM

So are you only searching for this C1180230 (is this a concern number ? data look so familiar)

Sharad
May 31, 2010 at 07:22 AM

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.

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
May 31, 2010 at 07:25 AM

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!