Hello!
I have a problem with Excel and VBA code. Let me first explain the situation. I have a folder called "Excel" and there are many Excel files. Also, in each Excel files' name there is a serial number, for example "14587454 File 1". Each of these files is a little different, but all contain a specific area that have the same headers A, B and C:
A B C aaaaaa bbbbbb 1287 ccccc ddddd 9647 eeeee fffff 3641
So this table is in all Excel files in the sheet "Cover", but on different row. Sometimes this table is on row 32 and sometimes on 35, depending on the Excel file.
The purpose is to create a Master Excel file that will copy this table from all Excel files in the folder and paste them to Master Excel, and sorts them according to serial number in the file name . In the Master Excel file I have a macro button and the copying should be done when this button is clicked.
I just started this project so I don't really have any sample VBA code. Could you guys help this newbie, please?
Be sure to ask if anything is unclear (which is very possible).
Bookmarks