And just to let you know i was using Visual basic Editor....Basic!?? Its harrrd!
I am a A-Level ICT Vce student and basically my teacher is very very crap. I have been set this assignment over the holidays which no one in my class understand becasue we havent had anything explained to us but when i told him no one understood marcro, he just did the first bit for me. I now how to finish it but dont have a clue what he has done.
What as far as i know we have to do is, to have one sheet in excel with a layout of one collum containing words such as "gas, electricity, water tv" and next to it, a seperate collum for the months going from january to december. In the spaces underneath the months needs to be some figures of money for how much they cost each month. underneath this, for each month needs to be an "UPDATE" macro button which updates these figures onto another sheet to record these figures. Here is the coding my teacher used for febuary in the first sheet:
Sub update()
MsgBox "macro running"
If Sheet2.Range("b1").Value = "January" Then
MsgBox "january"
Sheet3.Range("B3:b6").Value = Sheet2.Range("b2:b5").Value
ElseIf Sheet2.Range("b1").Value = "February" Then
MsgBox "february"
Sheet3.Range("c3:c6").Value = Sheet2.Range("b2:b5").Value
End If
End Sub
I have to do the same kind of coding for each of the months but i dont know how to create a macro button for a start. Ahh its all too confusing! But i wish i actually got taught something.
Thank you!
Anneka

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic