Can anybody please help me know how I can do this:
I have a file lets name it "result.xls" also I have lets say 100 files and
again suppose the names are "aa.xls", "bb.xls", ..., I want to put a combobox
in file, "result.xls" click on that I be able to see the names of those 100
files, then if I select one of them, this copy some data from various cells
in the source file and paste it to specific cells (e.g. B2:F4) in the
"result.xls" file.
Best
Darius