• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup Emp values, Traverse from right to Left to get the first 2 email occurrences of emp using VBA

V

Vijaychitra

New Member
Source Data

Emp #Employee NameEscalation Level 4 EmailEscalation Level 3 EmailEscalation Level 2 EmailEscalation Level 1 Email
1489AlexAlexesclation4test.comAlexesclation2test.com
1655JoeJoeesclation3test.com
1748Sam
1586PeterPeteresclation3@test.comPeteresclation2@test.com
1789LindaLindaesclation4@test.comLindaesclation3@test.comLindaesclation1@test.com

I need to get a report table using VBA which will fetch the first 2 occurrence of email ID for each Emp # - Traverse from right to Left in above table to get the first 2 email occurrences

Desired out put

Emp #Emp NameFirst MailSecond Mail
1489AlexAlexesclation2test.comAlexesclation4test.com
1655JoeJoeesclation3test.com
1748SamSamesclation1@test.com
1586PeterPeteresclation2@test.comPeteresclation3@test.com
1789LindaLindaesclation1@test.comLindaesclation3@test.com

Thanks for the help...
 
Vijaychitra
Isn't this same as Your previous threads last replies?

VLOOKUP or VBA to extract data from multiple sheets

Team, Need your help & Guidance to achieve the desired result using VB MACRO Attached the spreadsheet Raw Data Sheet - have 5 columns Report sheet - Desired sheet in the format as required. How to traverse the column from E-> C in raw data sheet for the emp #. Find the first mail ID column...
chandoo.org

Based Your previous thread's sample file... press [ Do It ]
 

Attachments

  • Excel_Help.xlsb
    20.6 KB · Views: 1
vletm said:
Vijaychitra
Isn't this same as Your previous threads last replies?

VLOOKUP or VBA to extract data from multiple sheets

Team, Need your help & Guidance to achieve the desired result using VB MACRO Attached the spreadsheet Raw Data Sheet - have 5 columns Report sheet - Desired sheet in the format as required. How to traverse the column from E-> C in raw data sheet for the emp #. Find the first mail ID column...
chandoo.org
Click to expand...
Requirement changed... Hence posted the new table
 
Vijaychitra
... the new table?
Do You refer to Your #1 reply?
... if You would like to get replies with Your new table then You should able to send new Excel-file which has it.
I used Your previous thread's file - as I wrote in #2 reply - just before You posted Your #3 reply.

One questions about Your the new table:
How do You explain 1748 Emp#?
... Source data has .. none emails and Desired Out Put has one email.
 
You must log in or register to reply here.
Back
Top