copy worksheet macro

  1. C

    VBA export worksheet not working correctly

    Hi all I recorded a macro to copy an existing worksheet into a new workbook, and assigned this to an existing button (form control) with text displayed as 'export report'. Once the duplicated worksheet is created in the new workbook the macro is also supposed to remove the button from the newly...
  2. H

    Copy worksheet tabs to other worksheets and rename

    Suppose I have a master workbook with 3 tabs "Master", "Quotation" and "Order" When I fill information in "Master" tab, forms will generate in the two tab. After that, I have to copy tabs to another workbooks, say "Quotation 2018.xlsx" and "Order form 2018.xlsx" (they are in the same folder...
  3. S

    Macro to copy sheets in new workbook based on company name

    Hello, I have a workbook with several sheets: AP, AR, GL, Expenses which all contain information about KPIs for different companies. Column A in each of the above sheets is a concatenation between columns B & C (used as a unique key for vlookup in other sheets which generate graphs). Column...
  4. L

    Great code just needs a small fix

    I found a code that works great for copying multiple workbooks to a master file but it creates a new file and copies to that file and I would like to see if someone could help me with getting it copy to the same workbook that the code is in. Thank you. Here is the complete code: Sub...
  5. D

    SOS--need help w/copying worksheet of formulas

    I have a rather large worksheet loaded with complex formulated cells. I need to copy the sheet and add it in other worksheets related to other dates. When I do this, within the formulated cell, there is a reference to the original worksheet i.e. October2010 example...
  6. M

    Disable Range Name Conflict Message

    Problem: I have a macro that deletes yesterday's worksheets and copy's in today's version. I'm adding about 90 worksheets. Upon each worksheet addition, I get a message reading... "A formula or sheet you want to move or copy contains the name "abcdef" which already exists in the destination...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top