I must begin by saying that my understanding of the advanced features of Excel is very limited. I am wondering if it is possible to use VBE to pull data from one Excel workbook and input it in another.
For instance the attached workbook gives a very basic example of a Tracking Log that my company will be compiling over the course of several months. The Tracking Log will include thousands of entries (rows). Each entry will have a status of either "open" or "closed". A second (separate) workbook, which I'll call the Update List, will need to be updated daily to show all entries from the Tracking Log that are still "open" (this will include entries that have never been closed, and entries that have been reopened after being closed).
Would it be possible to write VBE script that would enable the Update List workbook to pull all entries (by row) that are "open" from the Tracking Log workbook?
If so, could someone help me write this script?