Need VBA code to get two set of range from closed wb and 4 column to next sheet

Hi experts

i have old month file in local folder i want copy into into my active sheet to refer but its huge file take alot of time to open

i want copy from 2 set of range from closed wb(Master_File),sheet(Shride_Bridge_Data), A2:H2 and J2:Q2 add new sheet paste into active sheet in same range end with copy and paste 4 column from active sheet.


i store file in path C:\Users\Windows 10\Desktop\FY-2022

find the attachment

Try extracting the values using formula links:

Please Login or Register  to view this content.

HI sir

thanks for code i have nt got result as i expected please have a look

This is what i got result , not create new sheet and paste data from Master file.

Sorry - you stated you wanted ranges A2:H2 and J2:Q2 which is what my code did.

In reality to you want the entire sheet from the master workbook.

The best way to do that is to use a Power Query - open a new workbook, then choose Data / New Query / From File / From Workbook and the choose your file and go through the steps to select the sheet in the workbook that you want. PQ will pull the updated values from that workbook any time you update your query.