Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2017, 04:22 PM
eugeneradial eugeneradial is offline Use function to select another worksheet Windows 7 32bit Use function to select another worksheet Office 2003
Novice
Use function to select another worksheet
 
Join Date: Apr 2017
Posts: 2
eugeneradial is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-26-2017, 07:28 PM
Logit Logit is offline Use function to select another worksheet Windows 10 Use function to select another worksheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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
Resource :

https://analysistabs.com/vba/copy-worksheet/
Reply With Quote
  #3  
Old 04-27-2017, 04:53 AM
eugeneradial eugeneradial is offline Use function to select another worksheet Windows 7 32bit Use function to select another worksheet Office 2003
Novice
Use function to select another worksheet
 
Join Date: Apr 2017
Posts: 2
eugeneradial is on a distinguished road
Default Use function to select another worksheet

Thanks , I'll give this a try.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use function to select another worksheet Help with Index Function to Select Range of Cells bretyuin Excel 1 02-24-2016 05:11 AM
Use function to select another worksheet 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
Use function to select another worksheet How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Use function to select another worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft