That should be OK. I've been playing around with this a bit more (for my own amusement) and this pre-Beta version should pick up on the original data source and list other files of the same type (up to 5) in the same location.
That should be OK. I've been playing around with this a bit more (for my own amusement) and this pre-Beta version should pick up on the original data source and list other files of the same type (up to 5) in the same location.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'