Hi,
I have an excel userform which submits data via a command button and puts it on the next row of the spreadsheet. This is already coded and works fine, however: What I have within the userform is a primary listbox (named ListBox3) containing countries from which I need to select a few and add them to a secondary listbox (ListBox4) - and thus removing them from the primary (to avoid duplication in the listboxes). With this, there is a tricky part... I want to be able to submit the SAME data entered into the userform, but submitting it on a seperate row for each country selected. So for example:
ListBox3:
Albania
<item selected and moved to ListBox4>
Belgium
<item selected and moved to ListBox4>
South Africa
<item selected and moved to ListBox4>
Tunisia
<item selected and moved to ListBox4>
Zanzibar
<item selected and moved to ListBox4>
ListBox4:
(assume that Algeria, Belarus, Spain, Turkey and Zimbabwe were in ListBox3 and I selected them, moved it to ListBox 4 - thus removing it from Listbox3)
THEN (after submitting all data to spreadsheet, data should look like this):
Job Description Number Country
1 Telephone 09876 Algeria
1 Telephone 09876 Belarus
1 Telephone 09876 Spain
1 Telephone 09876 Turkey
1 Telephone 09876 Zimbabwe
Noting the same data for each row except for the country.
Can anyone help me with this, it's been driving me crazy! Thanks in advance!!
Jamie
Bookmarks