Copying a workbook cells from another workbook

ahs004

Board Regular
Joined
Jul 18, 2011
Messages
83
Hi,

I work for a company that has 10 regions. Each region needs to complete monthly data in the format that i have provided.
I then need to amalgamate this into 1 spreadsheet. I have used links in the past but had alot of broken links so the data was not reliable from month to month.
I need to create links using VBA from local region spreadsheets to my main spreadsheet where will copy the data into specific fields.

I have 10 identical spreadsheets with 9 table of data in each spreadsheet.
Need to copy each table from workbook 1 to 10 into my main workbook.
I have named the ranges but could not wirte the code to do this. I did try and record it but it takes too long as i will have to do it individually.

Is there a code that i could use the copy it range at a time? also each month the file will be at a different location but all spreadsheets in one folder. if possible will need to select or type the location to the code prior to copying the links.

Hope i made it clear.

I have happy to post a sample if required.

Thank you
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,211,686
Messages
6,103,298
Members
447,853
Latest member
olddutch7

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
Back
Top