When I run your script with the input box it moves the WBwip worksheet
"340-000-900 Pivot Table" completely out of WBwip and puts it into WB2.
The script would not be able to loop since you set it up to search for
"340-000-900 Pivot Table" in WBwip which, after the first run through,
is no longer there b/c it now resides in WB2. The only thing I'm
seeing happen (beyond it offsetting the activecell and then doing
nothing with this information that I noticed) is that it moves the
worksheet.
-When I did with it with the input box, everything worked
perfectly, but
if I had 10 projects I had to run the macro 10 times. I just want to
eliminate the input box and loop through the projects to achieve the
same results.-


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=541161