Hello All,
I think this should be easy, but I have scoured the internet and not found a workable solution. I have a worksheet named Test that I need to copy all sheets to a new worksheet called Final and paste Values only.
I will use this on 6 or 7 different worksheets with different numbers of sheets and different names.
I thought this would be super easy, but so far I have not found a workable solution. Any help is greatly appreciated.
Kelly
Last edited by jkelly228; 04-29-2011 at 04:23 PM.
Maybe something along these lines?
Adjust to your needs... Thank You , Mike
From VBA Express...
Please Login or Register to view this content.
Hi RealNiceGuy5000,
Thank you for the help. However, I think I was not clear. All of these sheets are actually in 1 workbook, and I need to move them to a 2nd workbook.
Workbook 1 = Test
Workbook 2 = Final
Sorry for the confusion.
I have found the below code, and I can get it to work to copy all sheets to a new workbook, but I want it to copy only values and formats, not formulas.
Any help is appreciated. Thanks
Kelly
Please Login or Register to view this content.
Maybe something like this?
Thank You, Mike
Please Login or Register to view this content.
Hi RealNiceGuy5000,
That worked perfectly. Thank you very much.
Kelly
Why copying ?
Please Login or Register to view this content.
Glad to be of some help.Originally Posted by jkelly228
.
Thank You, Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks