copy worksheet macro

  1. A

    Create multiple copies of a sheet by updating data from a web source

    Hi! I have an excel notebook (master notebook) with a main sheet and some other sheets containing some data used by the main sheet. The main sheet has a cell whose value is used by multiple queries in the supporting sheets to fetch data from a web source using an excel add-in. I have another...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...

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