Importing a range from another workbook

A

Andy Pilkington

Board Regular
Joined
Jan 23, 2014
Messages
83
Office Version
  1. 365
Platform
  1. Windows
I would like to import a range either by using a named range or he contents of individual cell into a workbook preferably y using a macro and without the need to open the other workbook.
Please can anyone help?

Thank you in anticipation.

Andy
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
You must log in or register to reply here.

Similar threads

SamarthSalunkhe
  • Question
Code to import data from another Workbook.
Replies
3
Views
744
Misca
M
SamarthSalunkhe
  • Question
VBA to Import data from another Workbook
Replies
2
Views
2K
SamarthSalunkhe
SamarthSalunkhe
SamarthSalunkhe
  • Question
Import data from another workbook pivot.
2
Replies
10
Views
722
Alex Blakenburg
A
E
  • Solved
Adapt VBA to import from subfolders
Replies
4
Views
795
excelboy92
E
M
  • Question
Macro Copy from Workbook to a different Workbook
Replies
1
Views
344
offthelip
O

Forum statistics

Threads
1,190,836
Messages
5,983,166
Members
439,824
Latest member
jr599

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top