I have a spreadsheet that has ID# in the first column and the shipment
tracking# in the 18th column. I made a userform with two textboxes for these
two items. There is a different sheet for each month and I would like it to
be able to cross months. I want it to look up the ID# provided by the user
in a text box and then put the tracking number provided by the user in a
text box in the 18th column of the row of the ID#. I have not been able to
code the command button to do this. The ID# are for documents many of which
are shipped on the same tracking number, so if the tracking number stayed in
the textbox that would be great.
Thanks