Does anyone know a way to quickly copy and paste the values from every sheet in a workbook into new sheets in the same workbook? I would want the names of the tabs to be similar (e.g., Sheet1 = Sheet1a) and would want to to make sure to copy any hidden cells... basically i want to get rid of all formatting and formulas.
Thanks!
somethign along these lines should work
Please Login or Register to view this content.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
hmm, definitely close. it creates the sheets and renames them, but is there a way to incorporate clearing the format?
as an example, if i manually select and copy an entire sheet, create a new sheet and paste the values, all the formatting is gone. no colors, crazy fonts, borders, highlighting, etc.
Try this
Please Login or Register to view this content.
that's perfect! thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks