#1
|
|||
|
|||
Use function to select another worksheet
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. |
#2
|
|||
|
|||
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’. Code:
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’. Code:
Sub CopySheet_SpecificWorkbook () ActiveSheet.Copy After:=Workbooks("YourWorkbookName.xls"). Sheets(“Sheet3”) End Sub https://analysistabs.com/vba/copy-worksheet/ |
#3
|
|||
|
|||
Use function to select another worksheet
Thanks , I'll give this a try.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Index Function to Select Range of Cells | bretyuin | Excel | 1 | 02-24-2016 05:11 AM |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
select text function is not working supposedly | albar | Word | 0 | 06-05-2015 08:25 AM |
How to summarise different worksheet to a summary worksheet | samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
"Auto-populating" data-worksheet to worksheet. | meggenm | Excel | 4 | 02-04-2012 02:04 AM |