move worksheets

  1. K

    VBA to Move Named Sheets to New Workbook & Save

    Hello Experts! I have a massive Excel file that I need to take specific worksheets (that have tables) to a new workbook, save as the tab name. I want to be able to specify which worksheets (that may, or may not be visible) that I want to have the code move/save. I have found two examples of...
  2. K

    Move a worsheet to another (open) workbook based on cell value

    Hi Guys, i know theré's a very similar post on this subject, but it is intended for use when you knwo the other workbook name. In my case, the workbook name will depend on date, client name and product. To cover this i have used some simple formulas using "concatenate" and "&" functions to get...
  3. JackDanIce

    Moving specific worksheets into a new workbook

    Hi, Probably a simple answer to this but seem to be struggling thinking of! I have a workbook with the following named worksheets: Balance Sheet Filter Original Data Remaining Filter1 Filter2 Static Data The number of 'Filter' worksheets varies depending on the existing macro's output. I...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top