Importing data from another workbook

[mickeystanford_alumni]

Hi guys,

I am trying to build a consolidated workbook which extracts data from other workbooks and sheets.

I would like to extract data from a workbook called (ALL_COUNTRIES) and a sheet in that workbook called (US_SALES).
From that sheet I would like to copy column (K:AU) and pastte to my new sheet which will be called (CONSOLIDATED) and paste it into A1.

Then, the US_SALES file has interactive data, so data will be changed weekly in there. I would like to run the code so that data changes into my CONSOLIDATED sheet by just running the code on a daily/weekly basis. I will then create a sheet called CONSOLIDATED_2 which will have formulas linked to the CONSOLIDATED, so running the code shouldn't affect those I guess.

Could you please help me?

Many thanks in advance for your support.

 

[AlanY]

suggest you have a look of the power query

youtube]6lBqYInBldk, list: PLBtvDJDZlIBphbvzi0P_7hYSbPMx0Smjv

 

[mickeystanford_alumni]

Hi Alan, thank you for your response.
I just find power query to bug/be less efficient than a VBA code which you run it and data then changes much more quickly than with power query. Added to the fact that with the power query, then your data has a table format which I do not want as I want to keep the original format from the original file.
Thank you sir.