Andy,
Sorry to jump in the middle of your post, but I am working an a project that requires a similar code.
I used the code from Rylos file in the earlier post to get started, but would like to expand the code to copy only two specific sheets "Summary" and "Equipment" to a new workbook (without selecting them each time) and then deleting a specified named range "Costs" from the "Equipment" sheet after pasting as values only in the new workbook.
I am pretty new to Visual Basic, and appreciate all the help I can get.
Thanks
Bookmarks