Hi,
I need some help with looping....
Using Excel 2003.

I have a list of some 30 000 rows. It has organization and person
information in following way:
Org1
Org2 (starting - just name of it)
Name2-1
Name2-2
...
Name2-N
Org2 (ending - just the name of it)
Org3 (starting - just name of it)
Name3-1
...
Name3-N
Org3 (ending - just the name of it)
Name1-1 (belongin to Org1)
....
Name1-N (belongin to Org1)
Org1 (ending - just the name of it)

I need to get the Org-name next to name column. I am not quite sure how to
make it in a way that it will check starting and ending and when ending there
might be person belongin to previous organization...

I have been able to get so far that it is filling up allrigtm, but when
ending and earlier organization should be returned, I cannot figure out how.
Oranization hierarchy is 5 levels.
Any help would be appreciated
Makelei