That is the easiest but I was hoping to find a way without adding an extra column to the first table. I want another person to be able to cut and paste data into the table 1 and have it update the weekly data. Are there any other options?
thanks