Hello,
How can i add to this code so that I am prompted via a dialog box of where the macro should paste data? In the case below, I would like to run the macro, it copies column A, asks me where to paste it (I answer/type "Mar") and then it will paste it under the month of Mar. I do this manually every month.
Thanks for any help. I appreciate it
Application.Goto Reference:="MTD_Expense"
Selection.Copy
Application.Goto Reference:="Mar"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
MTD Gas Expense Jan Feb Mar
10 25 13
120 25 14
30 10 10
160 60 37
How can i add to this code so that I am prompted via a dialog box of where the macro should paste data? In the case below, I would like to run the macro, it copies column A, asks me where to paste it (I answer/type "Mar") and then it will paste it under the month of Mar. I do this manually every month.
Thanks for any help. I appreciate it
Application.Goto Reference:="MTD_Expense"
Selection.Copy
Application.Goto Reference:="Mar"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
MTD Gas Expense Jan Feb Mar
10 25 13
120 25 14
30 10 10
160 60 37