format sheet info then export to text file

Is it possible to search a column for matching titles then extract the data from the other column cells
I have attached a excel file and hopefully final text file format where I have a group of titles each row would be a specific airdate and time for that title.
The title has multiple date and times but I want to combine them into one text file.
Sheet 1 is the list of titles and airdates
Sheet 2 is the final look then this would be exported to a text file
Sheet 3 is extra information to add to the final text file also.
I have captured a macro of the process but it is specific to one title and cells.
Thanks
Dale

Please Login or Register  to view this content.

Thanks tigeravatar that works great.
Dale

My incoming data has been altered slightly I was trying to edit the code to adapt but was not sure if I needed to duplicate ranges or not.
First, I need to use column A as my file name while column B is the first line of the text file and also the title to use for comparison.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The text file name would be from Column A, while first line of text file A1 would be Column B.

Then the next part is to change up where second line information and shifting the dates to look at column H - J

Please Login or Register  to view this content.

This seems to work but as soon as I add

Please Login or Register  to view this content.

Putting range C to G into A2 line of the text file it puts it in but adds stuff to A3?

Attached revised Excel

Thanks
Dale

The layout is not much different the reason for looking at a different column, the system wants to see a name like this "Chase, The.txt" while really it should display like "The Chase". This is only when there is a "The" or "A" at the beginning of the name.
The second line would be customizable via the excel, then I have a button calling up your script to export the text files. The column H - J would come from another excel file.
I am then reading the text file into another program and spliting up the string using the "~" or "^" characters.

Thanks
Dale


My Girl~CLP
0;00~6;00^10/7/2012~0~19:00
10/7/2012~0~12:00
10/7/2012~0~19:00

No, the program could have multiple airdates and times, and only the prime time version would be put in the second row.
example time ranges from 18:00 - 23:00 then if there are two it would be the version closest to the 21:00 hour.
Since this is different for each title I thought it would be easier for the person to enter the data in then hit the export to text button which calls your script.