Use VBA to automate entry of schedule, scores

[scotty68]

I have a spreadsheet to keep track of NFL scores every season. I have a formula to retrieve the scores on the right side from the scores on the left side. I would like to use VBA to automatically enter scores on the right side from the left side.