hi,

how can I cut and paste from a worksheet to another one of the same excel file the entire content of an interval of cells which contains formulas keeping the same values of the origin worksheet?

thanks a lot for a reply

Can't you upload your workbook and give examples of expected results?

thanks for reply; please see the attached file "example" as a simple example of my question
thanks again for your help

Attached Files

example.xlsx (10.9 KB, 11 views)

Can't you just make formulas in Sheet2 like:

=Sheet1!A4+Sheet1!C4 and copy down?

I think your problem is, that when copying/cutting and pasting the cell, all cell references will be to old sheet - i.e. you get formulas with links to old workbook. I'm right?

When copying the formula into another workbook, I select the source cell, and copy the formula from formula bar. After that I activate the cell in result workbook, and paste the formula into formula bar. When cell references in new workbook must be different, then I edit the copied formula in formula bar.
After that I can copy the cell with formula in target workbook into range I need it (Of-course with absolute and relative referenced set properly. And in case some formula has different parts with different reference rules, I have to edit the same formula e.g. columnwise too).

The process must be repeated for every different formula I want to copy.

OK. Scrap it!

Simply copy the range in 1st worksheet, activate the left top cell of range where you want the formulas, right-click on selected cell, and from dropdown select 'Paste Special', in Paste special windows check links, and press OK.

thanks for reply
I know that, ... this is just a simple example, but the real file I must work with has a lot of formulas to move in another sheet keeping in the formulas the cells of origin sheet; so I just asked if there was a fast way to do it witouht adding to the formula "Sheet1!"

Macro removed, because I think I misunderstood the question.
It would be helpfull if dugufo would be more clearly.

The quickest way I've found is to use the Find and replace option under the Home tab.
First select the cells you want to copy over and use Find and replace to change the = to a '= the copy your cells and paste them in your new sheet and then use find and replace to change the '= back to =

If you want to cut en paste (let's say) A1:H20 , do you want then to cut and paste only the content of cells with formulas or the content of all cells ?