Re: come on, somebody must know how to do this


THANKS TOM!

your explanation was very clear and the coding works to some extent,
but I see there is a lot of debugging to do. I still don't get the
results i was looking for. To making it more clear, let me illustrate
what I have and what I want to have.

I have a bunch of account numbers i.e:

1-11111
2-22222
3-33333
4-44444

When copying the information (personnel) from the other work*** and
pasting it next to rngitem, I want it to look like this:

1-11111 Apples
Bananas[INDENT]
[INDENT]Oranges
2-22222 N/A
3-33333 Heaven
Hell
4-44444 Nate
Rob
Allan

This is why I want it to shift the entire row. Is this clearer? The
results that I'm getting are not totally what I'm looking for, but I'm
trying to work from there. Any ideas on how to fix up the code? Thanks
in advance.


--
Sethaholic
------------------------------------------------------------------------
Sethaholic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25113
View this thread: http://www.excelforum.com/showthread.php?threadid=393952

.