Code won't copy from one sheet to another

[nikwak]

Although I have been using Excel for many years, i have never had to write a VBA code and in the present workbook I am working on, the time has come and I am totally at sea!
I am using Excel 2007 and basically what I want to do is to have two worksheets in the workbook - one called Workout and the other called Graph (which are all set up already).
I want to have figures put into cells in Workout (say the input cells are I8, I13 and I18) then those figures to transfer on to Graph in columns B, C and D respectively - that's the easy part! But now I want the person inputting figures to be able to change the figures in Workout next week and for those figures to transfer to the Graph worksheet but the row under last week's input. So, one week the figures will transfer to B3, C3, D3 etc and the next they will transfer to B2, C2, D2, etc leaving the last week's figures in Graph intact.
I have tried using the following formula but nothing seems to happen when I save it and try to input figures. I am really, really new to this VBA stuff and would appreciate someone coming back to me and explaining as simply as possible what I am doing wrong or what I should be doing. Here is the code I am using now to try and at least get one cell to transfer:

Please Login or Register  to view this content.

I've attached the spreadsheet as it is, so that it makes more sense. The figures in the Movement column in 'work out' need to transfer to the Graph sheet. Each week when new figures are in Movement they need to transfer to Graph but in next row down, etc

Many thanks, in advance
Nikwak

[royUK]

The workbook hasn't attached, try zipping it.

Why do you need to transfer the figures/ A graph can have the data on a separate sheet?

[nikwak]

Attached a zip file hope that works better.

What I basically want to do is give them a graph of sales for each venue from week to week using the Movement column. The only way I could think of doing this was to make another sheet with the week by week movement figures on it and using that - as next week when they enter the figures, the older figures will disappear on the work out sheet.
Hope that makes sense

Nick

[royUK]

I'm not sure exactly from your workbook, but this will transfer entries in work out, I8,I13 & I18 to the relevant columns in graph

Please Login or Register  to view this content.

[nikwak]

I know you're going to think I'm completely stupid but I have put that code into VBA and tried to run it and it won't run. As I said, I'm completely new to this VBA business. I have literally right clicked the work out worksheet and clicked on View Code. When the VBA box comes up I have put the code you have kindly sent and then saved. I then tried to Run and it won't and when I close it down and see if the code is working, nothing happens. I know I'm being stupid but what have I done (or not done!) wrong?

Nick