Hi,
Actually I want just to copy the organization info to I-column.
The structure is now
A-column I-column
Org1
Org2 (starts)
Fred - Org2
Smith - Org2
Wed
Org2 (ends)
Org3 (starts)
Jane
Smith - Org3
Thur - Org3
Org3 (ends)
Mike - Org1
Tom - Org1
Org1 (ends)


Thanks
Makelei


"Simon Lloyd" wrote:


So if i understand you right, you want to break that data out of one
column in to seperate columns but keeping the structure something like
this
Code:
--------------------
A B C D E F..............
Org1 John Smith Tue
Org2 Fred Smith Wed
Org3 Jane Smith Thur
--------------------


*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)

Makelei;308750 Wrote:
Sorry, that it is not clear...

All data is in column A.
When new organization starts there is name of the organization. Same
when
organization ends. Organization hierarcy is 5 levels. This means that
the
first organization level starts at row 1 and ends to the last used row.
Between these there is a list of organizations as level 2 to level 5.

In the middle of these two organization (start and end) rows there is a
list
of people belonging to this organization.

Now I should get the organization information to same row to column I.
The
problem is that when one organization ends there might be names that
are
belonging to mother/higher organization hiearchy, which starting row
was
before this ending organization started (and also ended).

Hopefully this clarifies a bit ;o)
Makelei

"Simon Lloyd" wrote:


I can't make out what you're query is, how is your data laid out in
columns? what is it that you would like to achieve?Makelei;308728
Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Looping help needed - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=86323)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86323