Hi all -
Is there a way to have a multiline textbox separate the values and put
each value into individual cells in a single column? Then apply the
values in the other textboxes (single line entries) to the other
related cells in each row?

For instance:


Truck# Notified Appointment Order#
ws1234 12/1/06 12/2/06 5am 546879
879213
213546


The above information is what would be obtained from the user form,
with the Order number being the multiline entry. I would like to
populate the underlying spreadsheet as shown below, so that
searchs/filters can be done on individual order numbers.


Truck# Notified Appointment Order#
ws1234 12/1/06 12/2/06 5am 546879
ws1234 12/1/06 12/2/06 5am 879213
ws1234 12/1/06 12/2/06 5am 213546


Any assistance/advice would be much appreciated