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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top