Hello everyone, I'd like to import data from another closed workbook by having a popup that'll let me search for the file, then select the range for which the data exists and import that into my current sheet.
The link below is a pretty good representation of what I would like to achieve, however, the range I'd like to is continuously changing workbook to workbook. For example, some workbooks are 20 cols by 40 rows, while some are 60 cols by 120 rows, so I'd like the vba to import the correct number of filled range: Macro to import data from another spreadsheet
Any help would be greatly appreciated. Thank you very much.
The link below is a pretty good representation of what I would like to achieve, however, the range I'd like to is continuously changing workbook to workbook. For example, some workbooks are 20 cols by 40 rows, while some are 60 cols by 120 rows, so I'd like the vba to import the correct number of filled range: Macro to import data from another spreadsheet
Any help would be greatly appreciated. Thank you very much.