use vba to copy cell values from one workbook to another

[reynastus]

Hi all

I have a worksheet that filled with formulas that figure out results and changes month to month. I am now trying to make another sheet that records the scores each month.

Any ideas? I'll work on getting a dummy file but don't have one on me at the moment

[arlu1201]

Your main file is already recording the values for the month. What is the use of the 2nd monthly file?

[reynastus]

Sorry it was not the clearest of questions. The reports page has calculations that are updated based on the current date and so the number changes month to month. The new sheet is to track those monthly scores so on Jan 1 I press a button and it puts the scores as they are on the reports page into the new page. Time goes on and then Feb 1 I do the same giving me two scores.

I'll get a copy of the spreadsheet to upload and make it easier to understand

Cheers
Rey

[reynastus]

Here is a very stripped down version of the spreadsheet I am talking about (as the original is too big to upload). Sheet 2 only has one formula working on it but that is not really that important.

The idea is that data is entered on the Yearlys! worksheet. Sheet2! calculates the percentages of each unit and when they have attended the particular course, Sheet3! is the sheet that I am looking into. The idea being that each month a button is pressed on Sheet3 and it is populated with the percentages from Sheet2! at that particular point in time.