new tabs

  1. C

    Copy and paste data into new tab, keep format and change tab names

    Hi, I have headers in row 1, with data underneath. For every change in column A, I want the data (plus the headers) copied and pasted into a new tab. I then want that tab to be named the same as the data then in cell A2 of the new tabs. So, if there are 7 rows with "Bananas", I want those 7...
  2. M

    Adding 1 new tab each week with a week number

    I need macro or VBA that will add a new tab each week with the current week number and clear certain cells . Any Ideas? Regards, Mark:eeek:
  3. R

    How to create many worksheets from master, Excel 2010

    I have been searching and searching and cannot find what I need. I am only an intermediate user, so if I have to use a macro or something, please walk me thru it. I have a master Excel 2010 book with approx 30 columns from A thru AD And 130 rows. Column A is sorted by last name, with only 26...
  4. M

    macro to add unknown number of tabs

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I'm working on an Excel tool that would allow me to visualize the status of different projects. Each project is contained in a separate tab named after its position (there are at the moment 12...
  5. T

    Moving Data to a new tab when it is complete

    Hello, I am having an issue where I need to move a row of data to a completed tab when it is complete. I want the macro to run each time I change the data in the status column, and when I type complete under a project, to move that project to the "completed" tab. I tried searching for this...
  6. C

    Copy/Paste files from folder into new spreadsheet with tabs

    I have a folder full of workbooks with one spreadsheet that I would like to be copied and pasted into a new destination spreadsheet. So, there are 16 files in this source folder, and they all have one tab with data called "Report". I want each of those 16 tabs to be copied over to the...
  7. C

    Macros

    I have created a worksheet for grading my students. Every year I have to copy the template sheet and rename it after each individual student. I have found a macros for creating new named worksheets. I have tried recording a macro of the repetitive process without success. I also am looking for a...

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