|Thanks for the quick response! I'm glad your able to help! |
I have several excel files located on a shared drive. They are located in the same folder labeled by the date (jan_01_10, jan_02_10, feb_01_10, ect). What I need the macro to do is to go into the folder, find the excel file (jan_01_10.exe), and import two cells to a separate report file. All of the dates need to be compliled into one worksheet. On all of the excel sheets in the folder on the shared drive, I need the same two cells imported.
I am trying to track daily production numbers per day and give an updating monthly average. Several individuals put data into daily tracking sheets. I need to compile all of this information into a common spreadsheet (which will end up being a graph) to let my department know how we are doing on a daily basis.
The second question I am asking is if at the end of the month, I can create a macro to start a new tab in the report workbook. For example a tab for January, February and March at the end of each month.
Thank you again