I need to create new files according to each supplier on my excel sheet. Example attached: BABYVISI has 3 lines, so a new file needs to be created in my documents folder called BABYVISI with those 3 lines of data in it. Each unique supplier needs to have a file created separately. I'll need to do this for over a thousand lines of data. Is this possible?
thanks!
Bookmarks