Ok, with a lot of help I have been able to create several excel vba modules and they have been unbelievable helpful, but I do not know where to begin with this one.
I have Column D that has a master number. In column E is misc info, Column F is the Main field that I need (product in this case) . In Column G thru AK are acceptable product names that match the master number. So what I need is to figure if there is a way to write a code that says:
For every number in column D, Check column G through AK for text. For text found in each column, I'll need to copy that master number, insert a row, put that master number in column D of new row and move the text from the original column G through AK to Column F in new row.
So my excel sheet looks like this:
Column D Column E Column F Column G Column H Column I Column J Etc
12345 XXXXXXX Soap Soap Bar Soap Crystal Soap Liquid Soap Foam
12222 XXXXXXX Soda Soda Can Soda Bottle blank blank
And I need it to become this:
Column D Column E Column F Column G Column H Column I Column J Etc
12345 XXXXXXX Soap
12345 XXXXXXX Soap Bar
12345 XXXXXXX Soap Crystal
12345 XXXXXXX Soap Liquid
12345 XXXXXXX Soap Foam
12222 XXXXXXX Soda
12222 XXXXXXX Soda Can
12222 XXXXXXX Soda Bottle
Is there a way to do this in code? I know how to search for specific data and copy it and move it with Select Case but asking it to look thru 31 columns ignore if they re blank and then copy the text in that column and another specific column is way out of my league. I have zero experience with loops.
Any and all code assistance would be greatly appreciated.
Kathy