Hi all,

Is there a way of selecting all w/s using VBA that have the same last
name typed in an input box? lets say the w/s is called "Bob Goes Here"
and another "Bob in here" and another "Bob over Here" etc is it
possible to type in an input box "Here" and have it select all sheets
with the last name "Here" and move them to a new workbook Named by the
name in the input box so in this case "Here.xls"?

Hope you can Help,

Regards,Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=547267