![]() |
reading data from 2nd file in 1st file using Combobox
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 |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com