Feb 02 2023 01:12 PM - edited Feb 02 2023 01:12 PM
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 working.
Also, I know this can be done by coping everything up to the first cell, but I want it to be copied underneath everything that is already on the first sheet. In addition, I want to know if there is a shortcut to copying every single sheet, and put everything into one sheet. Look at the picture below:
For instance, put number "2", "3" and every sheet after that, into "opgave 1" at the bottom, without losing formulas...
FOR MAC!
Thanks!
Feb 04 2023 10:38 AM
A lot (85 and counting) of people have looked at your question. Nobody has replied. When that happens it's usually because the question or the request isn't clear enough, or complete enough, for any of us to give a reasonable response. I think that's the case here.
It IS clear that you want to copy the contents of sheets 2 -3-4 to sheet 1. What's not clear--and might matter to a significant extent--is WHY you want to do this in the first place. You yourself make the point that you want everything in each of the copied sections to continue to work. And that is a good thing to worry about.
There was a reason, presumably, for creating the workbook with separate tabs before; has that changed somehow? If so, how?
Are you expecting the various sections to continue "to work" independently? Or are you doing this so as to produce a printed output of the collection? What is the bigger picture here (what's the whole workbook about in the first place?)?
Feb 04 2023 03:09 PM
Feb 04 2023 05:50 PM
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.