What I am having a problem with is changing the entry in the multiline text
box on the user form that needs to populate column D.

The user needs to have the ability to enter multiple order numbers coming in
on one truck/appointment. However when the data gets sent to the underlying
spreadsheet, each order number needs to have its own row.

"PY & Associates" wrote:

After importing,
activate a macro to check from last row up,
if last cell of col A is blank but last cell of col D is NOT blank, copy
next non blank A to C to last cell of col A,
iteration is under your control

Cheers

"NewBike" wrote in message
...
Unfortunately, Access is not an option at this point.

"Conan Kelly" wrote:

NewBike,

My suggestion is use MS Access. I think that it would me more
appropriate software to use than Excel.

Just my opinion,

Conan




"NewBike" wrote in message
...
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