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:
<tbody>
</tbody>
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.
ID | Date | Location | Object1 | Name1 | Name 1 |
ID | Date | Location | Object1 | Name1 | Name 2 |
ID | Date | Location | Object1 | Name1 | Name 3 |
ID | Date | Location | Object2 | Name1 | Name 1 |
ID | Date | Location | Object2 | Name1 | Name 2 |
ID | Date | Location | Object2 | Name1 | Name 3 |
ID | Date | Location | Object3 | Name1 | Name 1 |
ID | Date | Location | Object3 | Name1 | Name 2 |
ID | Date | Location | Object3 | Name1 | Name 3 |
<tbody>
</tbody>
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.