Thanks Simon,
I really do appreciate. Shall I send the sample to your email address?
Makelei

"Simon Lloyd" wrote:


No problem bearing with you Makelei, i guess now, as i am still having
trouble visualising what you have, i need to see a sample workbook to
try to devise something that would fit your requirement.

Makelei;308856 Wrote:
Hi,
Nope, I want to ONLY add organization (from previous rows) information
to
I-column. It is not available at the moment with the name. There is
other
information in columns B to H for each name and I need that
organization
information along with the name.

The challenge for me is that after one organization ends, there can be
names
for higher level organization. In example Mike and Tom belongs to Org1.

Amount of people varies per organization.

Thanks Simon bearing with me!
Makelei

"Simon Lloyd" wrote:

Makelei;308811 Wrote:
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's Profile: 'The Code Cage Forums - View Profile:
Simon
Lloyd' ('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'
('Looping help needed - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=86323))




--
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