Can A Macro Help Me?
 

Excellent. To be more specific, what I need to do is thus:

1. I have one file in which one column contains a list of Charge Codes
("codes"). For each of these codes, I need to locate that code within a
different file.
2. Each code has its own row of information. Once the code is located, there
are three conditions that I need to test for. First, I need to ensure that a
certain field in that row contains a certain letter (ie. A, not I). Second, I
need to verify that another certain field within that row contains a date
that is not in the past (ie. is after today). Lastly, I need to verify that
another field within that row contains one of three possible entries (ie.
says 123, 234, or 345 only).
3. I need some way of knowing which codes fail the above tests, possibly by
changing the cell/row's color, etc.

It seems that having two seperate files may complicate this process, in
which case I can easily copy the column of codes to be test from the first
file into the second. A second possible complication is that for each code
that I test (which comes from the first file), there will be a couple of rows
within the second file that have the same code, but differ in other fields,
and need to be tested. To put it another way, I need to run the test on every
instance of the code within the second file, not just the first instance.

Thank you in advance for your help!



"Jacob Skaria" wrote:

Definitely YES. Reply with more details so that someone here would help you.
If you have a code which you have already written post that too....

If this post helps click Yes
---------------
Jacob Skaria


"asmith87" wrote:

I've been given an assignment that I think an Excel Macro can help me with,
but I'm not sure. Here's what I need to do:

I need to search within the file for a certain code (to be located in a
certain column in the file), and once I've found that code I need to verify
that the information in the code's corresponding row meets a few certain
requirements (ie. a specific cell reads "A" not "I"). I need to do this for
1000+ codes, and be able to tell which codes do and which codes do not meet
the specified requirements.

Appreciate any input, anything from feasibility to suggested methods. Thank
you!