ok here's what I got so far, my problem is I don't know how can I use this in multiple sheets, what I mean is I have many csv files, over 100, so right now I need to apply the macro to each one, is there a way to read the original file name so my sheets are named xxx-12345.csv, where xxx is any name with different lengths.
Please note I need to add another sub plus so far I am just copying data in the same workbook, the end result, should be 3 separate csv files, one subroutine needs a function or a method to do this >>>
my source column looks like
Vehicle Warning Note
Cat Back Exhaust, Piping: 2.5", Tip: 1 Brushed Stainless, Tip Size: 2.5"
I need to output that in another sheet this way >>>
Part Number Attribute Name Attribute Value
600-0100 Piping 2.5"
600-0100 Tip 1 Brushed Stainless
600-0100 Tip Size 2.5"
I have another column called part number, but I need to split what's on warning note into the 3 or more separate rows duplicating the part number or leaving it blank so there are no confusions. Please note I didn't write that sub yet, the other two in the code section are working except for saving the each sheet to a separate one.
Bookmarks