Hi Shrivallabha,
Thanks for your kind welcome and assistance with my problem. The code works wonderfully! This will save me hours of tedious editing!
You have my sincere gratitude and thanks!
Ben
I'm working on a bill of materials that our company part number, manufacturer name, and manufacturer part number in columns (A,B,C). Our company part number may have one or more manufacturers for each part (maximum of 10). If there are more than one manufacturer, each are listed on separate...