HI,

I have a spreadsheet which contains two rows. The first row is a text string, while the second row is a filename:

Eg.

Mary had a little lamb Lamb.txt
Mary had a little sheep Sheep.txt
Mary had a goat Goat.txt
Mary had a ferret Ferret.txt

(Example data, not real of course. And there are over 1140 Rows populated with data in the same format)

What I would like to do is write a Macro that creates and saves a txt file for each row, containing the text from the first cell, and named after the contents of the second cell.

So I would have one file, called 'Lamb.txt', with the text "Mary had a little lamb " contained within it etc....

Any assistance would be appreciated.