VBA Loop Through List - Array & Check?

[jsneak]

Hi everyone,

I have a spreadsheet that has a column with "tasks" in them, there are spaces between some and not others etc (not my data set)

Is there a way of running some VBA that looks at each task within that column against a "master list" and have it return the differences? (If there are any - maybe a msgbox that lists the differences?)

I've attached a file that just has the alphabet on different rows and a master which has more of it.

Thanks in advance!

[davesexcel]

What do you mean by differences?

[jsneak]

So on the check sheet it goes down to R, but the master sheet goes all the way to Z. The msg box would list S - Z as missing.

I'm not sure if you can save them in an array or something? I hope this makes sense?

**Update - Found out how to list differences in msgbox**

So i've found a bit of code that does what i want - no idea how so if someone could explain it id be very grateful!

That being said, the code doesnt work with blank rows (which my data has) Can any shed some light on this, maybe adapt the code to skip the blanks?

Please Login or Register  to view this content.