Copy Like Data

Hello,
I have an Excel spreadsheets with two Sheets, containing Serial numbers and dates. One of them has the dates the Serial Number came into the area, and one of the has the date the serial number left the area. I need a program to Group the dates from the "Open" date next to the "Close" Date, so I can track the delta between the two. Any Suggestions? This will be updated weekly, so I would like to be able to Copy data into this sheet, and either click a button or Run a Marco with a shortcut. See the attached sheet

[NoSparks]

You may be able to keep this always current with a vlookup formula.

A VBA suggestion would be to loop through the serial numbers of one sheet
Use match or find on the other sheet
Offset to get the date
Datediff to get the delta.

A better answer could be provided if you actually do attach a sample workbook.

Sorry, thought I had.

[macropod]

You could do this with formulae as simple as:
=INDEX('Day Closed'!A:A,MATCH(B2,'Day Closed'!B:B,0))
=C2-A2
in C2 and D2, respectively, of your 'Day Opened' sheet, but that sheet and the 'Day Closed' sheets don't use the same data formatting - the latter evidently uses text formatting to preserve leading 0s, but the former appears to be numeric. You should use the same data formats for both sheets.