I need to copy a range of cells, into a matching workbook - but without it creating a link?
So the formulas live their own life in the new workbook without refrences
I need to copy a range of cells, into a matching workbook - but without it creating a link?
So the formulas live their own life in the new workbook without refrences
Just copy and paste...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Did you select a cell or the whole sheet? Try it with a whole sheet. Worked fine for me a moment ago!!
Select the cells with the formulae in the first workbook and copy. Go to the second workbook and simply paste. No links are created unless you are doing something other than that.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks