I have inherited a project from a previous employee and for the life of me I have no idea of why it did this the way he did.
Attached is an example of what I am dealing with, unfortunately is a HUGE file so doing this manually is just not an option.
Sheet 1 has two highlights yellow and green, the corrected output is on Sheet2. Essentially what they did was in Col B is have the part numbers for the product listed using “alt” + enter. This does not work for what I need to do (inventory control) so I need some code that will spit out Row 2 into 4 rows with the same data for each row as depicted on sheet2.
FYI the actual list is over 1000 lines long and the columns run all the way out to DA….. so you see how huge of a manual project this would be…..
Thank you for your help.
Bookmarks