Loop Through to replace all names on a worksheet

[UAL225]

Hello all,

Working on creating a loop to change the names on all the vendors to a set name. In this worksheet there are over 15,000 rows and about 287 vendors. What I am trying to achieve is to have "All Imports" as the main sheet and create a Sheet2 within the workbook to be used as a array to loop through. I want to do it this way, rather than hard-code the names, as they can change and more added over time, this way anyone will be able to control the names portion of the macro.

Any one have any ideas. Attached is a sample format

[jolivanes]

Maybe

Please Login or Register  to view this content.

However, if looping is your preference (would be slower).

Please Login or Register  to view this content.

This should be a faster loop as it works in memory and puts it in place after.

Please Login or Register  to view this content.

[sintek]

Another option...

Please Login or Register  to view this content.