Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need some VBA help
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 |