I followed the directions from the previous post, but this doesn't work. In
the drop down box there is only the worksheet that you copy from and "new
workbook". The other workbooks I have open are not listed in the drop down
box. What's the fix for this problem???????