I have attached a file and need help. I found code that is in the attached but it does not do exactly what I need.
What I need help with is.
1. Be able to find a file with date in file name wherer the date is less than 12 months from date on Sheet1 B2 then import Sheet2 into current workbook to Sheet2.
Example; If B2 = 9/31/13 then need to import file c:\filename_09_31_12.xls
Unless the file has revised at the end as c:\filename_09_31-12_revis
ed.xls then I need to import sheet2 of that file instead.
Thanks in advance