automatically have information from a wbk copied into my master excel database

I want to load an excel file onto excel and then automatically have the information copied into my master excel database. Can I do this with VBA?

Hello AnahiJessica,

Yes you can. We would need to see both workbooks to be able to provide you with a solution. You can post them as separate workbooks or together in a zip file.

Sincerely,
Leith Ross

have about 700 customer records that I received I get each record as .txt files and then I convert it into an excel format (see Bruce Freema.xls). All my XLS file are named differently.

What I usually do is copy and paste each customer record into my master.xls. I currently have too many to do this by hand. I am looking for a more efficient way of getting this done.

I wanted to have a system that it will allow me to upload a file and populate all fields to my master.xls, but I don’t know if this is possible with VBA.


Thank you for your help in advance.

Jessica