Code will only consolidate from one file and will get an error right after

Hi,

I am currently working on this project that will consolidate databases from multiple files. The code is not mine. I got this from one of the experts here. Unfortunately, I could not recall his/her name and I am unable to view that thread again(thanks to our company's deep freeze). It will only consolidate from Logger v2.1 and will get an error when getting the information from Logger v3.1. Can you please tell me what I did wrong? I am not good with coding and I just started learning MS Excel VB.

Another minor issue is that when I enter data into the database using the Logger v1.1, if I add a data using Posting ID and then add another data using Posting ID or Order ID, the previous data gets overwritten. Can you please help me with the code?

Please Login or Register  to view this content.

I attached my work. Thank you so much.

Hi jednified

Does Logger v1.1.xlsm not get consolidated?

Hi jednified

Try this Code...appears to do as you require...

Please Login or Register  to view this content.

Hi jednified

Compare this line of Code

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Other than that, I modified the Code to eliminate all the selecting.

Hi jednified

Yes, I should think you can do this

I can also create a button in excel to start consolidating the files

Assign the Code to the Button...

You're welcome...glad I could help. Thanks for the Rep.