Hello,
I've searched the forums and haven't found anything (maybe I overlooked what I'm looking for). I'm looking to pull data from multiple excel docs that have the same format into an access database and then have specific data in the database spit out onto a metric in excel. The attachment is the metrics but I've added the sheets "KC", "Texas", "St. Paul", and "Denver" for convenience. Those 4 tabs are examples of the docs I would need the data pulled from, imported into a database, and exported onto the "Executive Dashboard", "PDC Dashboard", and "Quality Dashboard" sheets. The data I'm looking to pull is "Units Processed", "% LFD", % LFR", % Non-Conformance's, "#1 Dealer for LFD/LFR" and "#1 Dealer for non-conformance's. The sheets "KC", "Texas", etc are never ending, so for example, every time a new "KC" excel doc is created and saved into a specific folder I need access to automatically pull the data from that doc and export it into the metrics. Please let me know if this is possible, I'm completely new to access.
Thank youPDC Metrics 12-9-16.zip