Loop based on a couple of conditions

[h_aesa1]

I am trying to have a loop go thru the data and then use a msgbox to display the results

I have 2000 rows of data, no blanks.

What i want to find is:

1.) Look at column P to see if the word "Open" appears

if so continue...if not, check next record

2.) If open appears then check 4 columns (corresponding) AA, AP, BA, BF to see if the word "Scheduled" appears

3.) if scheduled appears...go to next record

4.) If scheduled doesn't appear, then show msgbox with all the account numbers (column b) of the records that showed "Open" but without "Scheduled"


Hopefully this is easier than it looks...thanks for any help

JJ

[StephenR]

I suggest you attach a sample workbook.

[h_aesa1]

I have attached a sample workbook...hopefully this helps


thanks

JJ

[StephenR]

Try this. Autofilter would also be a good approach, but I couldn't get it to work.

Please Login or Register  to view this content.

[h_aesa1]

works awesome!!!!! thanks for all the help Stephen, appreciate it...


JJ

[h_aesa1]

I don't know if i am suppose to open a new thread as this one was solved.

I just had one question in regards to this post.


The code below works great.

My question is... How can I do the same code but only look in 2 columns (E & H) to see if both are empty, if both are empty, then flag.....

Hopefully that makes sense??

thanks,

JJ

[h_aesa1]

I posted a thread awhile back and it was solved with the below and it works great!!!

HOWEVER....

I want the code to use the same logic, loop thru all records, put results in msg box but i want the code only to check two columns now and only to see if they are empty.

If both column (E & H) are blank then keep a running list like above and show with msgbox...


thanks,

JJ

[shg]

Threads merged.

[StephenR]

If I understand correctly... Have added a comment to the line which has changed.

Please Login or Register  to view this content.