Jorrg1
05-13-2013, 03:26 PM
Hi
I have a macro that can import data from the first sheet in several workbooks into a single Workbook. The name of the workbooks (company A and company B), is linked to the sheets in the Master workbook, named "Macro". Please see the attached files.
The problem is that the macro only imports the first sheet from the workbooks (company A and company B). I want to be able to import the "import this" sheet, or at least to sheet number 3 from the workbooks.
Can anybody help me with this? I will be very greatful. Many thanks
kind regards
735736737735736737
I have a macro that can import data from the first sheet in several workbooks into a single Workbook. The name of the workbooks (company A and company B), is linked to the sheets in the Master workbook, named "Macro". Please see the attached files.
The problem is that the macro only imports the first sheet from the workbooks (company A and company B). I want to be able to import the "import this" sheet, or at least to sheet number 3 from the workbooks.
Can anybody help me with this? I will be very greatful. Many thanks
kind regards
735736737735736737