Should I loop this code or can I change range?

[cmcmullen42]

I'm currently trying to create a macro that will take updated information in one sheet and automatically update the next sheet. So far I have made it so it will update one cell...how do I make it so it will update all of the cells? Should I run a loop, or is there a way to change the range to include all of the cells? Needless to say, I have zero experience with VBA haha. Below is the code I currently have.

Private Sub CommandButton1_Click()
Dim CustomerName As String


Worksheets("Sheet1").Select
CustomerName = Range("C4")
Worksheets("Sheet2").Select
Worksheets("Sheet2").Range("C4").Select
ActiveCell.Value = CustomerName
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("C4").Select


MsgBox "Updated!"
End Sub

[cytop]

Please Login or Register  to view this content.

[Norie]

You've only posted code for one cell/value, so it's hard to tell what you are looping or what range you are working with.

Can you expand on what you want to do?

By the way, that code can be reduced a wee bit.

Please Login or Register  to view this content.

PS Can you add code tags?

[cmcmullen42]

Thanks for the reduced code! I'll just give the whole story so that I don't miss any points. I am a counselor in a school and have created a Sheet (Sheet1) that shows what classes students have passed/failed/haven't taken. This helps in programming for future semesters. The second sheet contains credit accumulation (So if a student passed they have 1 credit, if failed/need they have 0 credit. This helps show how many credits they have and how much they still need to graduate. Every semester these sheets have to be updated to show the newest grades and credit accumulation. Instead of updating both sheets, I would like to update one and have second sheet automatically update. (If I could format so that P=1 and F=0 automatically on the second sheet as well, that would be cool..). The columns go from A to AZ and there are 385 rows. Let me know if there is any more information I should include.
Never used a code tag before so I am going to try below now that I have this shortened code.

Please Login or Register  to view this content.

[cmcmullen42]

Alright! I figured out how to update the whole sheet...totally easy with that new code.

Please Login or Register  to view this content.

Now I guess my question is how to have the P to transfer as a 1 and F/NE to transfer as 0 on the second sheet.