LinkBack URL
About LinkBacks
Is it possible to move worksheets(with formula) from one workbook to another and only the values are transferred?
Thanks in advance.
Is it possible to move worksheets(with formula) from one workbook to another and only the values are transferred?
Thanks in advance.
If you MOVE the sheets, then the formulas will be in the sheet moved. But you can highlight all the cells, copy, then pastespecial > values to remove the formulas.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
so it is not possible? the thing is, if i do it in that way, the format of the worksheet backs to default.
The data that i'm about to copy is like report(like table listed form).
Those are the steps to remove the formulas after you have moved your sheet.Originally Posted by JBeaucaire
Maybe i'll be removing first the formula before i transfer the worksheet to another workbook.
Thanks for the replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks