General discussion


Find all instances of a cell value

By nulubez ·
I need to find all instances of a cell value from worksheet 1 on worksheet 2 and then depending on whether or not there is a specific value in another cell within that row make some calculations.

I will explain better:

"A1" holds unique occurrences of ID#s. I need to find ALL occurrences from another sheet and check to see if a specific value is present in another column within that row. If this is the case then I need to take the date associated with that specific occurrence and compare it to the one on the unique record.

I would like this to be in VBA not a formula. This is sloppy and does not work but I will paste what I have so you can get an idea of what I am trying to do.

Set Rng2 = Range("A9:A1009")
Set Rng3 = Range(ctNum)
For Each Cell In Rng2
rowNum = Cell.Row
For Each Row In Rng3
.....and so on....

I know this sounds confusing... I apologize - Let me know where I can clarify if needed.

Thanks in advance everyone!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums