merging two excel spreadsheets into a new one
 

I have been able to merge to spreadsheets into a new one using a macr
but I have two things that I would like to make this more functional

The first one is rather than just prompt the user for a file location
is it possible to use a drop down file menu similar to windows explore
?

The second one is how do you use dynamic ranges in a spreadsheet.
don't want to set values in the source spreadsheets as the values ar
being exported from another system and I don't want to have to modif
the files each time. I have tried many ways but am not sure how t
remove the the hard coded ranges. Any ideas ??

Thanks a lo

--
Message posted from http://www.ExcelForum.com