nedy_03
01-22-2008, 01:46 AM
Hello,
Long time no see, but still need u guys. I have this situation:
-> on column A I have a code (ex: 852996) that identifies a firm
-> on column B I have the phone number for avery code
A code may have one or more phone numbers, but they apperas on different rows. By ex:
__A___|_____ B_______|
852996 | 003903548798 |
852996 | 003906897896 |
823698 | 003902569874 |
852996 | 003902698756 |
Can u help me with a vb code that do the following:
- if it finds a code more than once, it takes the corispondig phone number of the 2nd, 3rd etc,. and puts it on the row where the code were found the first time, than delets the row 2,3, ... and so on?
The result should be :
__A___ |_____ B_______ |____ C______ |_____ D______ |
852996 | 0039035487987 | 003906897896 | 003902698756 |
823698 | 003902569874
Thank you ...
Nedy
Long time no see, but still need u guys. I have this situation:
-> on column A I have a code (ex: 852996) that identifies a firm
-> on column B I have the phone number for avery code
A code may have one or more phone numbers, but they apperas on different rows. By ex:
__A___|_____ B_______|
852996 | 003903548798 |
852996 | 003906897896 |
823698 | 003902569874 |
852996 | 003902698756 |
Can u help me with a vb code that do the following:
- if it finds a code more than once, it takes the corispondig phone number of the 2nd, 3rd etc,. and puts it on the row where the code were found the first time, than delets the row 2,3, ... and so on?
The result should be :
__A___ |_____ B_______ |____ C______ |_____ D______ |
852996 | 0039035487987 | 003906897896 | 003902698756 |
823698 | 003902569874
Thank you ...
Nedy