I've a problem that, some excel files with different years and different file name, I want that, when I select a year in Master record file, the data of all files in the same year folder, transfer to master file, Example: I'have 2014-2015, 2015-2016, 2016-2017 etc. folder, which have "ANADI BASU" with other file name, when I select 2014-2015 year from master record file, it will show all the different files data which exist in the 2014-2015 folder , same as when I select 2015-2016 year from master record file, it will show of collect all the different files data which exist in the 2015-2016 folder. please help me.
sorry for lengthy description and bad english
Bookmarks