Comparing Elements in Multiple Arrays

Hello all,

I'm relatively new to VBA and would appreciate any help. I'm trying to compare arrays with names stored in them and remove and save the matching elements to a new array. I'm assuming I will have to run an if statement within a for each loop for each array that I compare. To clarify, the user will paste the daily roster of names onto a worksheet, lets call DailyROSTER. Then a macro should be run to compare the names in that list to four other lists with names (Wrap, Pit, Problem Solve, Inbound) to see if there is a match. If there is, I'd like the names to be saved into a new array and have this array populate a drop down list. I'd also like the array with the DailyROSTER names stored in it to update and exclude those names that have been removed. (Redimming?)

At the very least, can someone show me how to save a worksheet's column that varies in size to an array? Thanks in advance!

Hello gibbsa08

Here's help.
Any other questions, ask.

Goodbye
Pan314


If you liked it hit the star button