Macro to Copy to a New File

[Rosey08]

Hello,

I have no knowledge of VBA, but used the macro recorder to create a macro that copies the output of my model into a new workbook. My problem is that I want to make changes to the model (sensitivity analysis) and then run the macro and have the new data be copied below the previous data set. My macro is copying it over the previous data. Can someone please help me make an adjustment so the macro so it will copy each iteration into the new workbook in an orderly fashion?

Hopefully this is a clear explanation of what I'm trying to do... Thank you!

 

[Dryver14]

can you copy and paste your recorded code on here between code tags?

 

[Rosey08]

Sub TestCopyMacro()
'
' TestCopyMacro Macro
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Application.Run "RiskRibbonEvent_DeferredCommandClick"
Application.Run "RiskRefreshRibbon"
Range("H2:I2").Select
Selection.Copy
ActiveWindow.ActivateNext
Application.Run "RiskRefreshRibbon"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

 

[Rosey08]

One of the things I left out of my first post is that I was having it run a monte carlo simulation using @RISK ...then copying the results to another workbook. Since you are looking into the code that may help understand what is going on.

Thanks again