Forum Discussion
Moving a sheet that contains a table to a different workbook witout using VBA
I created a table of stocks in a new workbook and would like to copy/move that sheet to a different workbook. How do I accomplish this without using VBA? Thank you!
I created a table of stocks in a new workbook and would like to copy/move that sheet to a different workbook. How do I accomplish this without using VBA?
What I would do is right click on the tab itself; then select "Move or Copy" from the menu that appears
You will be prompted for where to Move it to (new sheet, or to be added to an existing workbook) and then have also the option of whether to simply move, or to create a copy in that new destination. VBA doesn't get involved at all.
- I've tried this, but it will not copy/move the 'slicers' on the original sheet. Thank you!
