Get List of Text1 Values

[JaySonic7708]

I have looked and looked but cannot find a way to gather a unique listing of
the values that have been entered into a task field (for example text1). Sure
I can loop through all the tasks and logically gather a unique list, but that
can take a long time. I am really just trying to get a unique listing of the
values just like how MS Project does it when you select the autofilter
dropdown at the top of a column. Does anyone know of a way where this can be
done? I am not using project server so I do not have the luxury of querying a
database.

I anyone has any ideas at all, I will be very appreciative!!!!

 

[Jack Dahlgren]

The way to do it is loop through all the tasks and gather a unique listing.
Sorry, there is no other predefined method of doing this.
With VBA it should only take a very short amount of time unless you have a
huge file.

-Jack Dahlgren