copy worksheet macro

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

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

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

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

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

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

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