excel macro

[elenamccarthy]

I want to look at one excel sheet called "shipping and receiving log", I want it to find a "serial number" ex. W-111, then go to another excel sheet called "Serial Numbers" and find the correct instrument type ex. Worker. I want it to find the matching serial number from the first excel sheet ex. W-111, locate the date ex. 1-28-10 and then input it into the "shipping and receiving log". How would I write this up? Any code is appreciated.

 

[oldbrewer]

instead of having 2 workbooks can you have 2 sheets in the same workbook

or pull the data from the second workbook into your first workbook - that will make it simpler for you I think

 

[elenamccarthy]

See if you can look at this. C:\Users\emccarthy\Documents\EJHTMLe\TempJean.htm

If not i am not sure how to show you what i am trying to do.

 

[oldbrewer]

[TABLE="width: 929"]
<colgroup><col><col><col><col><col><col span="3"><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2"]Shipping and receiving Log[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date received[/TD]
[TD]RMA#[/TD]
[TD]Customer[/TD]
[TD]Model Number[/TD]
[TD]Serial Number[/TD]
[TD]cal[/TD]
[TD]ship date[/TD]
[TD]ship from[/TD]
[TD]Manufacturing Date[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9-18-17[/TD]
[TD="align: right"]12345[/TD]
[TD]****[/TD]
[TD]BT-1000[/TD]
[TD]BT-692[/TD]
[TD]c[/TD]
[TD]1-20-17[/TD]
[TD]UT[/TD]
[TD="align: right"]01/08/1997[/TD]
[TD]#####[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Serial Numbers[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Customer[/TD]
[TD]Model[/TD]
[TD]Serial Number[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/08/1997[/TD]
[TD]****[/TD]
[TD]BT-1000[/TD]
[TD]BT-692[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/08/1997[/TD]
[TD]fred[/TD]
[TD]BT-2000[/TD]
[TD]BT-777[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]#####[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=OFFSET($C$6,MATCH(D3,$C$7:$C$8,0),-2)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[elenamccarthy]

Thanks i will give this a try.

 

[elenamccarthy]

ok, so what if i have multiple serial numbers that are the same. Is there a way to take the born date and copy it to that same serial number?

 

[oldbrewer]

please post your data as is to refresh our memories as 3 weeks has elapsed....

 

[elenamccarthy]

[TABLE="width: 1172"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="align: center"]Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]RMA #[/TD]
[TD]Customer[/TD]
[TD]Model[/TD]
[TD]Serial #[/TD]
[TD]Cal = C[/TD]
[TD]Ship Date[/TD]
[TD]Shipped from[/TD]
[TD]Manufacturing Date[/TD]
[/TR]
[TR]
[TD]Received[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Repair = R[/TD]
[TD][/TD]
[TD]City, State[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Solution[/TD]
[TD]S-392[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Worker[/TD]
[TD][TABLE="width: 92"]
<tbody>[TR="class: grid"]
[TD="width: 92"]W-357[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]Worker Integra[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]LT-0193[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]BT-1000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]BT-1101[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]BT-1000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]BT-687[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 184"]
<tbody>[TR="class: grid"]
[TD="width: 184"]12/10/96[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]BT-IP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]IP-0194[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]MDT-100[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]MDT-1446[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]MDT-50[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]MDT-502[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]Verification Box[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]CF-743[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]MDT-100[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]MDT-1527[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]ES-1000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]ES-1036[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]LA-04[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]504350[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<tbody>[TR="class: grid"]
[TD="width: 131"]BT-1000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]BT-687[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR="class: grid"]
[TD="width: 77"]****[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 184"]
<tbody>[TR="class: grid"]
[TD="width: 184"]12/10/96[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i would like it to recognize duplicate serial numbers and take the manufacturing date and update it.

 

[oldbrewer]

so if say you have 3 identical serial numbers, do you want the latest date to be assigned to all three of them ?

 

[elenamccarthy]

well i want the date that it was made to be put in for all 3 of those matching serial numbers.

 

[oldbrewer]

so if bt 687 occurs anywhere higher up the list, you want the date from the nearest bt 687 above to be entered against the latest bt 687 ?