Hi,

ok I admit I'm not much cop at this so a cry for help....

I've got some data in Excel and got it into an array.. great...
now I want to loop through each entry and check the data... if it
matches certain criteria I need to put it into a separate array which
I will then slap back onto a sheet. The data has four values for each
line eg

lonUK, sheffUK, summer, holiday
mancUK, leedUK, autumn, holiday
parisFR, DubIR, spring, work

so i want to loop through the data checking the first two values, of
each record, if they contain UK or IR as the last two letters I want
to extract them into a separate array which I can then paste onto a
separate worksheet area. thats it but it's sort of got me in a
muddle.

any help apprecited

Bobsa