So I found an example online and modified it to use it as best I could. For the most part it works fine, but I randomly get bits of data being transferred over into random cells at any time without the button even being clicked. Is there a better way to go about doing this that won't produce those stray transfers?
Code:
Sub Transpose1_Click()
Worksheets("Authorization Codes").Range("B12:P111").Copy
Worksheets("1").Range("B5").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, SkipBlanks:=True
Application.CutCopyMode = False
Worksheets("Authorization Codes").Range("B12:P111").ClearContents
Worksheets("Authorization Codes").Cells.ClearComments
Worksheets("Authorization Codes").Range("B157") = 1
Worksheets("Authorization Codes").Range("C157") = 1
End Sub
Appreciate any advice anyone can offer up. Thanks!