copying data from Multiple worksheets

[LoganS]

Hi guys,

I noticed that there is allot of post's with similar issues as the one I am faceing but I could not figure out an answer from these post's this is why I am creating a new one.

I have 500 files that I need to run the same code on all of them , the files are named 1.htm, 2.htm, 3.htm...... all the way to 500.htm

the 1st file that the code will run on will be different as it will be placing the data in cells A2,B2,C2 the rest of the files it will look for the 1st empty cell in those columns and paste the data, I have created the below macro and it is exactly what I need but I need to find a way to loop the second part (starting from when I open the file 2.htm) without having to copy paste and edite the macro 500 times.

The Data.xlsb file will be the file containing all the data in it

Please Login or Register  to view this content.

[rollis13]

Something like this should work for you, just divide and fit in your macro:

Please Login or Register  to view this content.

[LoganS]

Actually I just finished the Macro , thanks for the help anyway, the below code works perfectly for me , I even added a message box to trigger another Macro in the end if clicked yes but removed it from the below code to avoid confusion

Please Login or Register  to view this content.

[rollis13]

Glad you got it working .

[xladept]

Here's another - a directory run style:

Please Login or Register  to view this content.