Hi Barrett,

I'd like to try this, but some questions first.

Is run# always four digits?

What worksheet in the E2APBX1897DV6-13-07 workbook contains the data
you want (or is there only one sheet)? Is the date format always m-d-
yy?

How do you determine, when doing this manually, which workbooks are
new? Does one of the cells "B1,D1,F4,D4,E4,K4,I4,J4 and K1" contain
the run number?

On Dec 6, 11:47 am, ST Jude wrote:
I need some coding for the following:
I have a workbook titled "ALL Trend Log" that does trend calculations for
me. I manually enter the data to calculate from another workbook and want to
make this automated.

Here's how the process works: people in my department make a new workbook
from a template and enter their data into it, using the exact same cells
every time. They then save these workbooks into a Windows folder titled
"E2APBX" in the format of Testname,run#,initials,date so it looks like this
"E2APBX1897DV6-13-07". The data I want from this sheet is located in cells
B1,D1,F4,D4,E4,K4,I4,J4 and K1. I then take this data and put it into another
workbook titled "ALL Trend Log" (found in Windows folder "Quant. Assay Trend
Logs") under the worksheet titled "E2APBX" into the respective cells A6
through I6. I do this every couple days by finding the new workbooks and
entering the data into the "ALL Trend Log." How can I get this to perform
automatically?

Thanks in advance to everyone for their help and insight. I have come to
really like this board and its professionalism.
Barrett