create sheet

  1. C

    Create Sheets with a cell name and based on a template

    Hello! I'm looking for a macro that can create a new sheet for all entries in a specific column based on a template. I know how to run the new tabs with the correct names, but I can't seem to figure out how to make those new sheets a copy of the template. For reference, my master sheet with all...
  2. A

    Create new sheet

    so I have 2 sheets and need to create a third one as follows: Sheet1 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> ID Name Code A001 A C1 A002 B C2 A003 C C3 A004 D C4 </tbody> Sheet2 <colgroup><col width="64"...
  3. N

    Create sheets from sheet based on value of column

    I have a Workbook with a sheet w/ rows that extend out to about column AT. Column B is the "Category" column. I want to have a macro that copies and splits the rows in each category into different sheets, each sheet title with the the category name, but still keep all the rows together in the...
  4. M

    Create new sheets named after each cell in a range. Do nothing if sheet is already created. Create if not.

    Hi all I have the following code but need to tweak it so that on the 2nd time it runs, it no longer creates every single sheet, but only new sheets (not yet on the workbook). Can anyone help? The purpose is to create new sheets based on sheet 'Template'. Also I'm having some trouble on the...
  5. S

    Create sheets and copy data based on value of a column

    I've got weekly reports that are lists of sales made by various reps. Each row lists a separate sale and it's associated data including the rep who made the sale. I need a script that creates a separate sheet for each rep listed and copies all the sales made by that rep onto the appropriate...

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