Transferring data from two Listboxes in a Userform to an Excel Table

[nrollo]

Is there any way to transfer data from two Listboxes (which hold separate data) from a UserForm into an Excel Table so it looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object1[/TD]
[TD]Name1[/TD]
[TD]Name 1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object1[/TD]
[TD]Name1[/TD]
[TD]Name 2[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object1[/TD]
[TD]Name1[/TD]
[TD]Name 3[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object2[/TD]
[TD]Name1[/TD]
[TD]Name 1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object2[/TD]
[TD]Name1[/TD]
[TD]Name 2[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object2[/TD]
[TD]Name1[/TD]
[TD]Name 3[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object3[/TD]
[TD]Name1[/TD]
[TD]Name 1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object3[/TD]
[TD]Name1[/TD]
[TD]Name 2[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Object3[/TD]
[TD]Name1[/TD]
[TD]Name 3[/TD]
[/TR]
</tbody>[/TABLE]

ID = MAX Count + 1
Date = DD/MM/YYYY (selected from the Calendar Object)
Location = Combobox (List comes from a different table)
Object = Listbox1 (items are added from a combobox into the listbox within the UserForm)
Name1 = Name 1 need to match for a later calculation
Name 1, 2 ,3 = Listbox2 (items are added from a different combobox into the listbox within the UserForm)

Sorry my information is a little vague, but that's the only way to describe it.