VBA open file, insert data, close file by tab.

Hi,

1. In your sample you have more than one "Cabbage" which would be the key word to open the file. So if "Cabbage CP" opens "Cabbage 2013" what does "Cabbage SA" open?
2. All your tabs have different columns? what's the column you want to copy and when does the data start?
3. Where is the location of the files to import?
4. Every time you import do you want to add new data or replace the data completely.

I hope that's not a lot of questions.

Thanks

Thank you for the quick reponse!
1. Anything with the same first word will go to the same file. "Cabbage CP" and "Cabbage SA" open the same Cabbage 2013 file. The destination file looks exactly like the source file i posted but its much longer.
2. I mainly need the last columns that are in black boxes
3. C:\Master Products
4. I need a running total of the data. I create a new file once every year.

Sorry if I double or triple posted. I kept putting the wrong name/ location for the destination folder.

Thanks for any help!

Can you post a sample of Cabbage 2013? I still see different headers in the file tabs.

Thanks

Sure! I attached a 100 line sample and filtered by date.

Please let me know if you need anything else or have any suggestions on how to get started

Hi,

I am sorry I could not reply earlier. I was looking at your code. With the new requirements and all the new information I cannot come up with a solution. The main problem here is to determine whats copied already and what has not.

Hopefully someone else will help us with this.

I was wondering maybe a Vlookup from different workbooks is all that's needed.

I am sorry I cannot help

Do you think it would help if I number the transactions/lines. This way I can set a tiny macro at the end to remove the dupes?