Hi, new to excel macro programming and was wondering if someone had a
suggestion for how I might do this.

I have some CSVs that i'm trying to process through excel. Essentially I
want to run a macro that will insert a column in a specific location (not a
problem), then it will go down each row in the previous column to look at
each cell, and if it's empty, it leaves the new cell in the next column
blank. If it finds text, such as "Item 1", it will put a part number in the
next column, like "TDI19384".

I'm trying to give it 8-10 product names, and when it finds a match, it
throws the SKU in the next column. Any suggestions are appreciated

Pete