Import data from several files into one sheet, special case

Hello,

I read a lot of theads about data gathering from different files but my case is a bit different and I would appriciate your help for this case.


we i have several exel files, and i want to copy information from second sheet with name DATA to one master file on sheet with same name.


for exapmle

George.xls information from DATA SHEET
Nick.xls information from DATA SHEET
John.xls information from DATA SHEET

to one Master workbooks Data sheet

files are located in one folder.

range is from A7 to T7 and until A3000 and T3000

operation to do is copy, paste special in master file.

I am quite newbie in VBA and please please don't judge me much

Thanks before hand

Welcome to the forum.

I have a couple of questions for you -

1. You said the range is from A7 to T7 until row 3000. Is the header in row 7 or row 8?
2. Does the master file have the header or should the macro insert it?
3. If you run the macro the 1st time and data gets populated, if you want to run the macro a 2nd time, should the data in the master file be cleared and fresh data input?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.

Change this line in your code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Also, ensure the headers are already present in your Master file. If you want the macro to input them for you, let me know.

sorry for asking

but what do you mean by headers.


I supposed it was jus names of coloumns of data for example

name | last name | age | ets. |

Yes..you are right.

What error are you getting?

What is the error showing up in the small box where the debug window is present?

You can also attach a sample file that you are using, so i can troubleshoot it for you.

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Try this updated code. Put this code into the Master file.

Please Login or Register  to view this content.

Have you copied the code to the master file in a standard module? I ran it at my end and it worked fine.

Here is the master file with the macro and the output in the DATA tab.

Gazteknokrat,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.