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!
8 Replies
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!
- The presence of slicers wasn't mentioned in your original request. I was wondering why the simple, straight forward approach wasn't used. I move/copy "tables of stocks" and related data frequently.
- Or just copy and paste?
- Copy /paste di not carry all the data (slicers, in this case). Thanks
- Moving a sheet that contains a table to a different workbook witout using VBA
online tool? go or c# dotnet ?- I'm not aware of any online tool that would accomplish this...I don't know any C++ programming...And, I've never heard of 'dotnet'. Thankk you!
