I created a calendar with a lot of data fields that need to be entered daily. This data gets copied to a master schedule, but occasionally needs to be edited. I created a macro that simply copies and pastes the master calendar data back into the editable calendar so users don't have to start over, however I'm wondering if a better way to do this is possible as it takes several minutes to use the copy/paste macro I recorded to complete. Here's a snippet of the macro:
Code
Sub Schedule_Transpose_Week1()
' Schedule_Transpose_Week1 Macro
Range("N8:O8").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[36]C[61]"
Range("I10:M10").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[34]C[67]"
Range("I11:M11").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[33]C[68]"
Range("I12:M12").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[32]C[69]"
Range("I13:M13").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[31]C[70]"
Range("H15:I15").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[29]C[72]"