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