Export GP record in Excel to individual .txt files

Hello All - help please!

I have long-term health problems, and keep all documents in a folder. I have recently downloaded my GP medical history in a PDF format, and have copied and pasted this into an Excel (2019) workbook.
Some of the entries just have a date, but some have a date and time, and there are often multiple entries for one day, some with times and some without.
What I would like is to use this Excel file to create a .txt file for each entry, with the name of the file relating to the date and time of the entry and the person making the entry which shows on the second line. For those without times, they could either not show a time, or show 00:00. In fact, it would be easy enough for me to reformat the ones without times as 'dd/mm/yyyy hh:mm' and they will then show as 00:00.
I would like the following file name format, including the spaces, WITH 'NAME OF PERSON' being what appears on the second line of each entry:

YYYY-MM-DD - HH:MM NAME OF PERSON - NHS GP Consultation entry

I have attached a small example file, though the actual PDF is over 100 pages. (Note all my personal data and that of other individuals has been changed). I've also attached a screen grab of page 1 of the PDF file.

User 'hungt' helped me with something similar in February, which worked perfectly, but unfortunately doesn't deal with the multiple entries for one day, and also adding the date and the person's name to the filename.

TIA

Code in Module1

Please Login or Register  to view this content.

I suggest changing the filename definition in case of duplicate. The changed parts are in red.

Please Login or Register  to view this content.

Hi Hungt -

Thanks, but I seem to be getting an error. I pasted your second text into a workbook, but when I run it I get a "Run-time error '6': Overflow" error, and then it highlights the 5th line "data = .Range("A1:A" & lastRow + 1).Value ' we will take an extra row at the end of the table"

I've attached screenshots.

Apologies if I am doing something stupid; I'm a total novice at all of this.

Screenshot2 2025-05-31.jpgScreenshot 1 2025-05-31.jpg

I don't have an error. Besides, this line can't cause an error even if there is no data in column A.

I'm attaching the file.

Hi -

It worked! Sorry, I obviously did something stupid the first time. Then it worked, but only for some of the data, until I discovered that some of the data that I'd copied across had come over as weird symbols and there were errors. Once I corrected all of that it worked perfectly.

I'm really very grateful for your help, which has been incredibly useful at a difficult time in my life.

Thanks!