duplicate sheet

  1. W

    VBA Duplicate sheet in excel workbook.

    Hey All, This has been driving me crazy, and I can't seem to find an answer anywhere. I'm creating a document at work for creating new item products. The workbooks currently has one sheet visible and the rest hidden. The hidden pages do all the work with lists, and Vlookups ect. The Visible...
  2. I

    Duplicate excelsheet by clicking a specific cell in excel. Possible?

    Hi everyone, First I must say that this forum is awesome. Everybody wants to help! So to my question. Is it possible to create a macro that makes it possible to duplicate the activated sheet by clicking a cell (Something like a "hyperlink"). Is this possible to do? I would be grateful if...
  3. B

    Duplicate, rename sheet but not if it already exist..

    I have this code that duplicated my main sheet and renames is based on a cell value. My problem I don't want to duplicate the sheet if it already exist, which is going to happen A LOT. I need help making this happen. Below is what I have so far. Dim MySheetName As String MySheetName =...
  4. N

    Macro for creating sheet

    I have a sheet named say "A". I have to create a duplicate sheet in the same workbook and rename it as "B" which can be done as <Code> Sheets("A").Copy After:=Sheets(1) Sheets("A (2)").Name = "B" </code> But the problem is I want to create this new sheet "B" immediately after "A" where the...
  5. V

    (VBA) Duplicate sheet and rename the copied sheet

    Hi, I'm trying to feed information from a MSProject file to an excel workbook. I want that for every uncompleted task that is a non-summary task, that I duplicate a sheet in the excel workbook and rename it to the Text1 field value of the task. The template sheet is the 2nd sheet and is named...

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