copying worksheets

I was able to get my macro to work with the code below and then I was asked to tweak a little and now I'm having problems again. Assistance on the tweaks to my code is greatly appreciated. The tweaks I am to add: 1) Add a keyboard shortcut. However, when I do this, the macro stops running at...

Hi Guys, First time poster. Need your help. I've got about 500 excel that are in "C:\Test" Folder. I want to generate a macro that: loops through all the files in the folder For each excel file in the folder (1.xlsx,...) copy all worksheets into a new workbook with the same filename as the...

This should be a fairly simple question, I've already got the code for copying sorted, I'm just curious about several of the named ranges within the sheet and what happens to them when I copy it all over. I'm working from a spreadsheet made by my predecessor and they've got a template sheet...

Hi, I'm trying to set up a macro that copies over 2 tabs (named "Template Summary" & "Template Data") and renames the copied tabs based on a list (the list is on a tab called "Impacts"). The Summary tab is linked to the data tab and as such when they are copied I need the new summary tab to look...

Hello! :confused: I am trying to copy a worksheet about 20 times and then I need to rename each worksheet by a string name. For Example: ActiveSheet.Name = "VOTD Non-EXW" ActiveSheet.Name = "VOTD Non-Pharma" ActiveSheet.Name = "VOTD Pharma" I found the...