Macro to loop through dynamic number of rows checking adjacent for certain criteria

OK I have a complicated (for me anyway!) bit of code to write:

I need my macro to go through X number of rows,

and for each row I need it to check all the columns to the right (this will also be dynamic),

if it finds a "Y" I need it to check the corresponding value in row 4 for "Yes",

if every "Y" corresponds to a "Yes" then i need it to print "Ready".

If any of the "Y" correspond to a "no" I need to to print "Not Ready".



Any help at all would be greatly appreciated!! I'm running excel 2013. Thank you!

Just to make sure I understand. What do you mean by "print "Ready"". Is this a literal statement? As in you actually want a printer to print out a sheet a paper with the words "Ready" on it?

if it finds a "Y" I need it to check the corresponding value in row 4 for "Yes",

Do you mean row 1?

Hi stnkynts,

Sorry - I do mean row one and no I just want it to say "Ready" or "Not Ready" in column A of the appropriate row.

Thank you!!

What about rows in which there is both a "Y" corresponding to a "Yes" and a "Y" corresponding to a "No". Row 13 for example. How should those be treated. Should it say "Might Be Ready"?

So if any "Y"s correspond to a No then it should say "not ready", for it to say "ready" every single "Y" in that particular row must correspond to a Yes.

I really appreciate this btw!

Here you go. Note my comments on how I approached the problem to try to minimize the time it takes for the code to run. Even still, it took about 2 seconds to run on my computer. It is the way it is when you need to go through each individual cell. There are some other more advanced ways to do it, but this works and doesn't take up to much of my time.

Please Login or Register  to view this content.

Oh my god you're a rock star!

Thank you so much, it works perfectly you absolute legend! I am in your debt.