You can do a couple of things to get the sample to me, you could 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, or you could upload your workbook to a site
where it can be downloaded from, or you could email it to me but i won't
get it until tomorrow at simonDOTlloydATthecodecageDOTcom (of course
substitute the words in captils for what they should be)

Makelei;310407 Wrote:
Hi,
This works OK until there shoud be organization that is earlier in the
list
- see example of Mike - Org1 and Tom - Org1. Org1 has started
earlier and
names are comin later on in the list.

Sub A08OrgsWithName()
Dim LRw, i, Org, Org1, Org2, Org3, Org4, Org5
Columns("I:M").ClearContents
LRw = Cells(Rows.Count, "E").End(xlUp).Row

Org1 = Range("A4").Value

For i = 8 To LRw
If (Left(Range("A" & i).Value, 2) = 50 And Len(Range("A" & i).Value)
7) Or (Left(Range("B" & i).Value, 2) = 50 And Len(Range("B" &
i).Value)
7) Then
Org1 = Range("A" & i).Value & Range("B" & i).Value
Org = Org1
Else
End If

Range("K" & i).Value = Org
' Range("M" & i).Value = Range("A" & i).Value & Left(Org1, 8)
Next i

End Sub

Makelei

"Makelei" wrote:

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