Forum Discussion
Can you copy an entire sheet into another existing sheet?
Hello, I was wondering if there is a way to copy an entire sheet/project into an existing sheet/project. This has to be done while every formula on the second project doesn't break or end up not work...
Hello. Thanks for your concern.
It has changed from previously. Previously, I had multiple Excel documents, consisting of 1 task. Then, I found a setting where I could interwine multiple documents, into 1 document which resulted in the screenshot. This made it easier for me, personally, to navigate within my files instead of have several different Excel documents open at the same time.
Now, however, I would like to put everything into just one sheet, but I tend to get an error message saying I only can paste in the first row and cell. Even if I do that, the formulas are often broken, also if copy-pasted to the bottom of sheet 1.
Thus, why I would like that, is because I have many sheets (even more than what the screenshots shows) and I want to use the search function in Excel to search for “xx” so it will be easier to find all the different hits, instead of “wasting time” by navigating to the next sheet, then search for hits, then next sheet and search for a hit, etc.
It is meant to reduce my time during an “accounting” Exam to search (command F) for “x” information in 1 tab, so clicking on different documents/sheets, etc. wont be necessary.
When copied correctly over to sheet 1, the remaining sheets will be deleted since everything will be in 1 large document.
I hope this makes sense.
It has changed from previously. Previously, I had multiple Excel documents, consisting of 1 task. Then, I found a setting where I could interwine multiple documents, into 1 document which resulted in the screenshot. This made it easier for me, personally, to navigate within my files instead of have several different Excel documents open at the same time.
Now, however, I would like to put everything into just one sheet, but I tend to get an error message saying I only can paste in the first row and cell. Even if I do that, the formulas are often broken, also if copy-pasted to the bottom of sheet 1.
Thus, why I would like that, is because I have many sheets (even more than what the screenshots shows) and I want to use the search function in Excel to search for “xx” so it will be easier to find all the different hits, instead of “wasting time” by navigating to the next sheet, then search for hits, then next sheet and search for a hit, etc.
It is meant to reduce my time during an “accounting” Exam to search (command F) for “x” information in 1 tab, so clicking on different documents/sheets, etc. wont be necessary.
When copied correctly over to sheet 1, the remaining sheets will be deleted since everything will be in 1 large document.
I hope this makes sense.
Thus, why I would like that, is because I have many sheets (even more than what the screenshots shows) and I want to use the search function in Excel to search for “xx” so it will be easier to find all the different hits, instead of “wasting time” by navigating to the next sheet, then search for hits, then next sheet and search for a hit, etc.
I'm on a Mac as well. And the Find dialog box gives you the option of searching through the entire workbook for that elusive "xx" Note the "Within" selection below. You can choose "Workbook" there and have a search through everything.
So, given the problems you've experienced with broken formulas, etc., it seems to me that your reason offers insufficient benefits to outweigh the potential costs.