split worksheet

  1. C

    split worksheets based on dropdown

    Good morning, I have a report with 500 separate account results - these are currently set up as a self serve via a dropdown. What I want to do is create 500 separate split worksheets based on the dropdown choice. However I want each worksheet to display all the results /charts etc which are set...
  2. P

    Split Worksheet Into Multiple Workbooks Based on Column Value

    Hi! Using VBA I'd like to split an Excel worksheet into multiple workbooks based on each unique value in Column B. The header name for Column B is "Acronym". Each Workbook would contain the same column headers as the master file. The Excel format is .xlsx I want the file name to be "Column B...
  3. usansay18

    Need to Customize an Exisitng Macro - Splits 1st Worksheet into Mutiple Worksheet Tabs

    Hi, I got this macro that basically filters Column A in sheet 1 and copies and paste the data based on this criteria into multiple tabs, if that makes sense? So I have a bunch of columns of data and in column A is the Manager. But then it splits the data by manager into multiple tabs in the...
  4. C

    Split sheet into workbooks using a workbook template based on data in column A

    Thank you in advance for any help. I've looked through several threads already and can't seem to find one that fits my exact scenario. I have a workbook that has a sheet called CustInvData, this sheet contains 4,421 rows of invoice transaction data for 178 customers starting on row 2 (headers...
    • coreysmith
    • Thread
    • split sheet to template split sheet to workbooks split worksheet
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top