Use function to select another worksheet

[eugeneradial]

While in an Excel spreadsheet, I would like to use a function or command to import another worksheet that contains formulas. What is the best way to do this? Thanks in advance for your help.

[Logit]

VBA Copy Worksheet: To Specific Workbook

Either macro needs to be pasted into a Routine Module in the workbook you are copying FROM.

Please find the below example, It will show you how to Copy the Worksheet named ‘Sheet1’ to Specific workbook before ‘Sheet3’.

Sub CopySheet_SpecificWorkbook ()
Sheets("Sheet1").Copy Before:=Workbooks("YourWorkbookName.xls").Sheets(“Sheet3”)
End Sub

Please find the below example, It will Copy the active worksheet to Specific workbook after ‘Sheet3’.

Sub CopySheet_SpecificWorkbook ()
ActiveSheet.Copy After:=Workbooks("YourWorkbookName.xls"). Sheets(“Sheet3”)
End Sub

Resource :

https://analysistabs.com/vba/copy-worksheet/

[eugeneradial]

Thanks , I'll give this a try.