Hey guys, I posted a question relating to this same work task I was
working on last week and got some great responses. I am having one
other problem I thought you guys might be able to help me with...


Here is a screenshot of what I am working with. (I altered the names
and the last 6 digits of the account numbers, but the XXXX exist in the
document I am working with as well)

I have attached a sample of the original data as EXCELBEFORE.JPG.

If you look at the other two attachments, excelafter1.jpg and
excelafter2.jpg, these show what I want the data to look like. I want
to replicate the name listed in collumn B automatically in collumn A
until the new name is shown in collumn B. I had to break apart the
last 2 pictures to make them smaller than the 100k limit.

I achieved the results shown in the jpgs by hand, which was easy for
only 3 or 4 names. However, I have to do this for over 2000, which is
a very daunting task. A nice formula could help me out a lot, but I
just can figure out how to get it to work...

Thanks for the help.

-Brendan


+-------------------------------------------------------------------+
|Filename: excelafter2.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=5100 |
+-------------------------------------------------------------------+

--
destrolennox
------------------------------------------------------------------------
destrolennox's Profile: http://www.excelforum.com/member.php...o&userid=36503
View this thread: http://www.excelforum.com/showthread...hreadid=564903