How can I combine multiple sheets into one sheet?
Hi there!
I currently have 23 separate sheets, all with the same headers that are currently separated by location. I now want to combine all 23 sheets into one so that I can easily pull data from the sheets into a dashboard. How I can I combine the rows from each of these sheets into one sheet?
Best Answer
-
Hi @Weston Barnes,
You could go into each sheet, select all rows, right-click and select "Copy to Another Sheet" or "Move to Another Sheet", and then select the sheet you want them moved or copied to. Do this for each sheet except for the one that everything is being copied into.
Best of luck!
BRgds,
-Ray
Answers
-
Hi @Weston Barnes,
You could go into each sheet, select all rows, right-click and select "Copy to Another Sheet" or "Move to Another Sheet", and then select the sheet you want them moved or copied to. Do this for each sheet except for the one that everything is being copied into.
Best of luck!
BRgds,
-Ray
-
Thank you so much, Ray! If the original sheet that I move the rows from is updated after I copy the rows, the new/combined sheet will not be updated in real time, correct?
-
That's correct. It's a once and done action. There's nothing waiting for future updates that would apply them to another location.
BRgds,
-Ray