W
Will
1. right click summary sheet
2. select move or copy
3. under "to book" drop down select new book
4. also select create copy check box at bottom
5. now you have that 1 sheet on its own new file
6. select all then paste special - values to rid any links
if you want.
2. select move or copy
3. under "to book" drop down select new book
4. also select create copy check box at bottom
5. now you have that 1 sheet on its own new file
6. select all then paste special - values to rid any links
if you want.