Hi Everyone,

I have a small company that receives orders via an excel file. The excel order forms are always exactly same. I've attached three example order forms. I need to keep track of how much we are selling of each item in a master excel file. Is there a way to extract the data from each file in the folder and add it together into a master excel file? This needs to be a simple solution, since we are continuously receiving orders and need to continuously update this master file. Also, I am running excel 2011 on a mac.

I already posted this problem a few weeks ago and I got some great answers but we couldn't get the macro to work on mac. Here is the thread:
HTML Code: 
Here is the macro code I was trying:
Please Login or Register  to view this content.
Thanks in advance for the help,
Kyle


Master-1.xlsm
Order Form ex3.xlsx
Order Form ex2.xlsx
Order Form ex1.xlsx