Userform repeat all data to next row except unique field from listbox

Ok, heres what I want to do - whether it can be done is another matter!

I have a userform which puts all data on next row of spreadsheet (this works fine).
I have recently had to add a listbox of countries to the userform (this is made from a list on sheet2, works fine).
BUT, the list of countries selected on the listbox needs to have the same data as what's on the rest of the userform, but to be on seperate rows (one row per country selected).

So essentially:

Job no: Job: Country:
123 Make tea Germany
123 Make tea France
123 Make tea UK
123 Make tea Australia
123 Make tea Egypt
123 Make tea Iraq

Please note that all info (job no, Job) is the same except the country.

Does this make sense, and is it possible please?

Is your Listbox multiselect?

If it is then perhaps something along these lines would help.

Please Login or Register  to view this content.

Hi,

Thanks Norie, yes it is multiselect, I'm currently trying to implement your code into my userform but i's taking a while as I have many fields to offset. I will let you know how I get on once I have finished. Thanks kindly for your prompt help!