Delete array elements from 1 column if they appear in another column. Both column in array

Hi all

due to an addition of data in a control workbook the displayed elements in a dynamic userform, (courtesy of GregM from this site), have become too many to display due to screen size. As a workaround to avoid a major redesign I want to limit a displayed column by splitting it into 2.

The problem is though that if the date elements are not present in column 3 they are lost to many other sections of the database.

It is for that reason, as the the array is collected, or just before completion, I would like to limit the elements in Column 3 by deleting (or not adding to array) if a date entry also appears in column 6. I'm not sure does this fall into the category of redimming the first element of an array.

Limiting their entry into to the array is probably the way to go and I'll keep looking at that.

Any pointers appreciated, I have tried a few methods including limiting the number of rows when dealing when column3 but none successful.

The array is collection by UDF

Please Login or Register  to view this content.

mvaEmployeeData is array format Variant/Variant (1 to 21, 1 to 6)

And a dummy workbook attached. The yellow area denotes the original limits of the database

In an ideal world the proper solution would be that if entries exceed a specific number a second (overspill) column is created, moving everything across, but that is for another day