Match and change value of the cell

[SirMaceOne]

Hi all VBA masters Bellow you can see my part of code which is selecting cells for my report. One of the columns has name supervisor but the value is a number not name of supervisor...my question is how to change from number to name and surname. The list of the supervisors name must be in the different worksheet.

Please Login or Register  to view this content.

End Sub

[JLGWhiz]

Assume the list of names is in sheet 2, Column A beginning in row 2 with the corresponding number in column B and the range with the number you want to find is in sheet2, Column A somewhere. To change all the numbers in column A sheet 2 to names.

Please Login or Register  to view this content.

Since you did not provide any information about where your data is located on the sheets, nor the sheet names, then you will need to adapt this code to your actual sheets and data.

Also, this forum requires that you use code tags when posting code. You can edit your orignal post, select the code by highlighting it with the mouse pointer, then click the pound (#) symbol in the tool bar of the reply pane. Then click the "Post Reply" button.

[SirMaceOne]

Hi JLGWhiz, Thanks for answer can you help change code...more details: source is in worksheet 'WOC' range A2:B16 column A = name of supervisor column B = number. Second worksheet name is 'CopyDataTheView' that is my main worksheet where I must change numbers. Supervisor numbers are in column H23 down to 200 rows.

[SirMaceOne]

Hi JLGWhiz, Thanks for answer can you help change code...more details: source is in worksheet 'WOC' range A2:B16 column A = name of supervisor column B = number. Second worksheet name is 'CopyDataTheView' that is my main worksheet where I must change numbers. Supervisor numbers are in column H23 down to 200 rows.

[JLGWhiz]

Please Login or Register  to view this content.

[SirMaceOne]

Please Login or Register  to view this content.

thanks for help ... macro works but I have encountered another problem. When I added a macro to my workbook to the button when I want fill the table with the names I have to press the button a several times. Is it possible to make a loop ...

[JLGWhiz]

The macro does loop column B for each item of data starting in row 2 and working downward. What other loop did you want?

[JLGWhiz]

Maybe this is what you were looking for.

Please Login or Register  to view this content.

[SirMaceOne]

Hi Big thanks for helping me...I have added macro from you to my workbook it is works like I want but with some error. I have prepared fake copy to show you what kind of problem I have. Code is clear for me but I don't understand where is the problem.

[JLGWhiz]

This should work better.

Please Login or Register  to view this content.

Or this one will be faster.

Please Login or Register  to view this content.