Hermes44
04-15-2010, 07:08 AM
I'm looking for a way for my worksheet, when you enter a date into A1, will search a specific folder on a drive to find the appropriate file. Then for it to display the values from different worksheets within that found file.So, I would enter the date in A1(eg: 01/04/2010) in workbook called "Check". This would then search the folder S: Data\Report archive\2010 for the subfolder for the month(eg: April) and then search for the specific day. This found workbook contains three worksheets titled Grave, Day, Night. The macro would then display the contents of cells M48:P53 from each of these worksheets into the cells in the "Check" workbook.I hope this makes sense. I am new to macros/VBA so only have a rudementary understanding of them. All help and explanations are greatly appreciated.