I have two columns one of which has filenames and the other having values. I need help creating a macro that takes each value from a cell outputs it into a text file and then saves it with the filename of the cell next to the value. I'll need it to go down the columns and create separate text files for each. These files would be html files. And it would be like say I have one column with cat, dog, cow. The column next to it would have cat.html, dog.html, cow.html. The first column would make up all the text within the text file and the second would be the file name. So after the macros are done I would open up cat.html and find it only having the word cat within it and so forth.