Copy one range and paste in another range
Below is a macro, just copy and paste it into a module in your workbook and go from there.
This macro uses message boxes to help you select the range to copy and paste but it can easily be modified to fit into any macro where you may need it.
Sub PasteLink()
Dim rngToCopy As Range
Dim rngToPaste As Range
'Select your range to copy
Set rngToCopy = Application.InputBox("Select range in Book A", Type:=8)
Windows("Book2").Activate
'Select a single cell you wish to start your paste
Set rngToPaste = Application.InputBox("Select range to Paste in Book B", Type:=8)
rngToCopy.Copy
rngToPaste.Activate
ActiveSheet.Paste Link:=True
End Sub
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to copy and paste data using a Macro in Excel. I'll show you multiple ways to do this,...
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Tutorial: In this tutorial I am going to introduce the idea of Logic in Formulas. A Logic test is a ...
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Tutorial: How to limit the amount that a user can enter into a range of cells in Excel. This works...
Tutorial: How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or ...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)