LinkBack URL
About LinkBacks
I want to be able to select x number of cells and copy and paste them into another workbook and have their formulas transfer exactly like "copy" means. Why must I go in and copy the actual formula, seems way more complicated than necessary.
I want to be able to select x number of cells and copy and paste them into another workbook and have their formulas transfer exactly like "copy" means. Why must I go in and copy the actual formula, seems way more complicated than necessary.
Excel typically auto-adjusts range references when you copy a formula. For example, if you drag a formula down, all the copies will reference the row they are on.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I don't understand what you mean. You can copy and paste more than one cell at a time.
When copying formulas though, if the ranges are not absolute (denoted by "$" symbols), the ranges will change depending on where you paste them.
For example, if you copy and paste A1 into A2, and the formula in A1 was "=SUM(Z10:Z20)", the formula in A2 will be "=SUM(Z11:Z21)" unless the formula in A1 was =SUM(Z$10:Z$21).
63falcon. Not into another workbook. Copy from workbook A to workbook B.
or if you can, then it isn't as simple as copy/paste
If you are looking to move the formulas from workbook A into workbook B and keep the references to the original cells of workbook A, you have to use cut/paste.
Edit: Removed.
But then I lose the formulas in workbook A!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks