Create new datasheet to store data

[henaxe]

Hello folk's

Anyone know how to create a macro that cuts all info from datasheet1 and insert it to a new datasheet?

Problem is that I'm working in a program named Pulse LabShop, the program exports its data to a specific Excel document. We run several simulations and for every simulation the excel document is changing to the new values.

I guess that the best way to go around this problem is to create a script that cuts out the data and paste it to a new datasheet. Run the macro each time after a new simulation is not a problem. Number of different simulations is ten.

Can anyone help me? Thanks in advance

 

[VoG]

Try this

Sub CopySheet()
Sheets("Sheet1").Copy after:=Sheets(Sheets.count)
End Sub

 

[henaxe]

Fantastic! Thank you very much!