Hello:
Please refer to attached file.
I have data in column A:C as shown.
I need VB Code to give the output of the data as shown in column G (Column I shows mapping).
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have data in column A:C as shown.
I need VB Code to give the output of the data as shown in column G (Column I shows mapping).
Let me know if you have any questions.
Thanks.
Riz
Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Another way if column D is empty
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hello spitfireblue and Mike:
Thanks a lot, this will work for me.
Riz
...and if you want a standard Excel formula that avoids VBA and loops (which may take time if large ranges are involved) then in E3 copied down (making sure column D is blank)
copied down for n * 4 rows where n is the number of names.Please Login or Register to view this content.
In the sheet display options deselect the 'show a zero where cells are blank' option.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks