I have a number of Excel files that are all of the same general design with several sheets each.
I have added a number of formulas to one of them. These formulas reference cells within other sheets within that workbook.
I don't want to start over with all of the other workbooks so of course I just want to copy this group of formulas over to each of the other workbooks.
But when I copy these formulas, they not only include the sheet specification, but the workbook itself. It's nearly as cumbersome to go through and remove the workbook specification as it would be to re-enter all of the formulas from scratch. Is there a way to get it to copy without it wanting to point back to itself?
Thank you.
I have added a number of formulas to one of them. These formulas reference cells within other sheets within that workbook.
I don't want to start over with all of the other workbooks so of course I just want to copy this group of formulas over to each of the other workbooks.
But when I copy these formulas, they not only include the sheet specification, but the workbook itself. It's nearly as cumbersome to go through and remove the workbook specification as it would be to re-enter all of the formulas from scratch. Is there a way to get it to copy without it wanting to point back to itself?
Thank you.