new worksheets

  1. M

    Moving multiple sets of columns to new tabs via VBA

    Hello, We get an excel data sheet sent to us weekly that has security information all on one excel worksheet - each security has two columns (ie - A:B, C:D, E:F, etc etc), and we need to copy each security to its own worksheet and save that sheet as a text file for my company to import this...
    • mjd
    • Thread
    • columns excel new worksheets security vba
    • Replies: 5
    • Forum: Excel Questions
  2. Small Paul

    Separate Rows Based on Content & Place in Different Worksheets

    Hi I have a worksheet [report] which has defining content in column A, e.g. A1 - 5 A2 - 5 A3 - 7 A4 - 8 A5 - 8 etc I need to have a new worksheet opened for each (5,7,8) and the content placed in row 10 of the tab. Please, can anyone help? Regards Small Paul.
  3. M

    Need to create new sheets with names from Array

    Hi Experts, I need to create new worksheets using the names stored in an Array, however, when I run my code it creates the right amount of sheets, but the names are not been assigned to the new worksheets, so I was wondering if one of you could point my mistake, below is my code: Sub...
    • mpatino
    • Thread
    • array dim name worksheets new worksheets wsname
    • Replies: 3
    • Forum: Excel Questions
  4. E

    Automatically Refresh, Add new sheet using template if needed

    Please bear with me as I am pretty new with Excel VBA. I have a code that I found on the internet that I have somewhat modified to fit my purpose. What I am trying to do is this: I have a master sheet, and a template sheet. The macro grabs information from the master sheet, then takes the...

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