Now we talking :-)
Performed quick test.
Glenn your code works now, although it miss delimiter ";" in created hash file...
Richard your code now works perfectly, dont know if you changed anything..
Gargoyle unfortunately I cannot make your code work, it still give same error; array reference out of bounds! even when changed to your latest suggestion
Wittos your code is actually the one which matches my need best, the only problem is that you manually enter "managers", which in my case means manually entering more the 50 managers in the code. If we could have a step before that filter out the managers and then populate the lists as in your code, then the circle would be closed and my need fulfilled!
To all, I also found that when I saved the the original Excel file as csv with comma delimited, it actually saves the file with semicolon ";" and not comma ",". I saw that when I opened it with notepad ++.
Now back to more testing/learning :-)
_________________________
"... Great minds talk about idea' s, average minds talk about events and samll minds talks about people...!"