Copy one sheet from a workbook to a master workbook VB

[jsfannon]

I have a workbook that has multiple tabes one is named simpson i have created a new workbook named Simpson PAC the 2nd sheet on this workbook has formulas I was needing help copying the 2nd sheet on the Simpson PAc workbook to the workbook name NEW Pac Tool that also has a sheet named simpson any help would be appreciated. Thank you

 

[jsfannon]

 

[SirJB7]

Hi, jsfannon!

From first workbook (source) right/alternative click on second sheet , Move or Copy, check create a copy, in workbook target select the new one, select Before Sheet option as wanted, and OK.

Regards!

 

[jsfannon]

Thank you SirJB7. I was wanting this data to automatically import over is there a macro I could do this with?

 

[SirJB7]

Hi, jsfannon!


-----

[pre]

Option Explicit

Sub Macro1()
'
' Macro1 Macro
'

'
Windows("Libro1").Activate
Sheets("Hoja2").Select
Range("A1:J10").Select
Selection.Copy
Windows("Libro2").Activate
Sheets("Hoja2").Select
ActiveSheet.Paste
End Sub

[/pre]
-----


This is a recorded macro that takes a range (A1:J10) of sheet Hoja2 in workbook Libro1.xlsm and copies it to A1:J10 of sheet Hoja2 in workbook Libro2.xlsm. The macro should be placed in any module of workbook Libro1.xlsm.


Is that what you were looking for?


Regards!