Hi
am new to Macro, Need your Help..!!
I have around 200+ excel files in folders and Sub folders, all files have "All Levels" sheet, what I want is to have an pop-up in my Master Sheet prompting for File name based on Partial file name I enter which matches with file names in directories and Sub-Directories it has to copy data from "All Levels" sheet of those files into my Master Sheet.