Nirmall
02-11-2016, 09:24 AM
I have created a master workbook, where a sheet has formulas and it is from A1:Z70.
Now i have many workbooks, where each workbook has one sheet with data in it.The data in those sheets are within the range mentioned above.
Now say there are 30 such workbooks in a folder, and when i open the the master workbook and enter the the file name of one of the 30 excel workbooks, it should import data from that particular workbook, without opening it , by jus running a macro.
How do i do this, any help would be appreciated
Now i have many workbooks, where each workbook has one sheet with data in it.The data in those sheets are within the range mentioned above.
Now say there are 30 such workbooks in a folder, and when i open the the master workbook and enter the the file name of one of the 30 excel workbooks, it should import data from that particular workbook, without opening it , by jus running a macro.
How do i do this, any help would be appreciated