General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Find all instances of a cell value
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!