Apologies in advance for my inability. I honestly have no idea how to handle this! I've only just started doing VBA, and only for specific tasks. So far Google and StackOverflow has provided what I was looking for, but I cannot find anything that explains what I am trying to do.

Any advice would be greatly appreciated!

I am looking to populate a number of SQL scripts using data from Excel.

In one column there is a list of usernames. In an adjacent column, there is a list of locations.

I have a template of a SQL script, and I need a TXT file generated for each location, with the relevant users inserted.

For example, if this were the data set: