Hi everybody and greetings from Norway
I want to be able to create a macro that can import data from same sheet in multiple workbooks into a single Workbook. All the files are in the same folder.
Attached files:
- Macro
- ComapanyA
- Company B
CompanyA.xlsxCompanyB.xlsxMacro.xlsm
Detailed explanation:
1) I want the VBA code to be made created in the "Macro" excel file.
2) I want to import the sheet "import this" from the CompanyA and CompanyB files. These are sheet number 3 in each company file. It would be best to link it to the name "import this", or link it to sheet number three.
3) I want the sheets from the company a file and company b file, to be imported to the CompanyA and CompanyB sheets in the "Macro" file.
Thank you very much
kind regards
Jørgen Harsem
Bookmarks