copy sheet

Hello, i have been so frustrated with this below: I have about 100 files and they all have this tab call "Oracle". Some of the file the "Oracle" tab is protected, some are not protected, some are protected with a password call 'ch'. My co-worker and I have been working on this issue but...

Hello, I need help creating the following part of a macro. I have information that will be on sheet 1 in the following format: Column A,Column B,Column C,Column D,Column E File Number,Field Name,Changed From,Changed To, Modified By I will have up to 14 sheets one for each person making a...

Hi all. I have a macro (see code below) that copies a worksheet (Sheet1) from a closed workbook into Sheet1 of the active workbook. So far, so good but I need the path to the closed workbook to be taken from a cell in the active workbook which is populated by a drop-down combo box. I have named...

I wish to make new sheets from a large worksheet of data. The data for these sheets will be based on groups of states and designations (red or green). So if Group 1 is the TexArkAna states, I want a sheet for group 1 red, and another for group 1 green. I then want to export these 2 new sheets...

In a moment of poor planning, I published a workbook (set up like a form, for people to fill out) without having a page for me that compiles all the fields nicely for easy collation. So the form includes on sheet1: Name: [--------------------]...Date: [------------] Address: [---------...

In my workbook, I am calculating the collection of oil and water on an hourly basis and subtotaling on a 24 hr basis for several days/weeks in a row. I need the subsequent sheets after the first 24hr sheet to continue their formula and 'carry over' the previous sheets data. I've done this...

Hi I am very new at this. I would like som help with a vb-code to copy whole sheets from one excel to another. The Excel that I would like to copy from has a lot of sheets and i would like to copy a few of them by entering the names of the sheets in the script since the order of sheets might...

I have designed a few somewhat complex graphs in Excel 2007 and whish to deploy these as an add-in. I have hence added the sheets with the graphs into my add-in and created a few buttons to copy this sheet into the ActiveWorkbook. The problem I'm encountering is graph is using several named...

I have designed a couple of graphs using named ranges to give dynamics to the number of series in a chart. This works fine as long as I don't want to copy and/or move the sheet to a new work book. When I do this, Excel chooses to remove all references to the named ranges in the SERIES forumla...

I need to a workbook in a specified folder, copy any sheet that contains "Dec" to a new workbook, save and repeat for all worksbooks in a folder Here is the code I have so far and it only opens all the files in the folder I specified but doesn't take the action to copy the sheets I have...

I need to copy sheets from one workbook to an other using VBA. But I am having some trouble with named ranges. Both the source file and the detination file have identical data sheets which contains various data - including a large number of named ranges. These are used for lookup functions...

I've been having this problem for a while now, It is only an annoyance, But it starting to Drive me crazy. I have made a Budget and this is the only thing I couldn't find out why and have not find any help anywhere. My Budget is setup so that for each Month there is a seperate sheet, So I keep...

I have the following piece of code which copies worksheets, renames them, based on values from a range and puts that value in a specified cell in the copied worksheet. This all works fine but I'd like to add fuctionality to it so that when the macro is run again it creates worksheets in the same...

In my workbook I have an excel sheet(called state_sum) with a some vlookups, arrays, and other basic formulas. The values on this sheet change based the state selected in cell A2. I need to find a way of summing all of the values for a group for a region. For example the midwest - I would...