Copy & Paste Macro

[AprilCovington]

Hello, this is my first post.

I am trying to create a Macro to copy data from Sheet 1 and paste it into cell A1 in Sheet 2.

For some reason when I run the macro, it does not paste anything to Sheet 2.

Can you please help me? Thanks!

[davesexcel]

Supply the code you are having problems with...

[AprilCovington]

Sub HelpMe()
'
' HelpMe Macro
'

'
Rows("1:28").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Range("C2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "Event "
Columns("E:E").Select
Range("E2").Activate
Selection.Delete Shift:=xlToLeft
Columns("G:G").Select
Range("G2").Activate
Selection.Delete Shift:=xlToLeft
Cells.Select
Cells.EntireColumn.AutoFit
End Sub

[davesexcel]

Are you running the code from a different sheet, or from sheet2?
If you need the code to copy from a different sheet other than sheet2, you would have to show that in the code.

[AprilCovington]

I on Sheet 1 when running the macro

[AprilCovington]

When I am on Sheet 1 and hit Run Macro, it acts like it is running but just paste blank data cells on Sheet 2. The data from Sheet 1 is not pasted over.