copy worksheets

Hi all, I am a true newbie on VBA and I would very much appreciate help on the below issue: I have an initial workbook “Tehnicieni” with 3 sheets as follows: SheetA – containing formulas and charts based on the table from SheetC; SheetB – containing formulas and charts based on the table...

Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...

Hello, I am attempting to do the following: Copy all worksheets whose name ends in "-PP" into a new workbook (formats, values - NO formulas) Open a pop-up box in the new workbook that asks the user to enter the version number Open the save as window and save the file to the user's desktop as...

Hello I need a code for selecting and copying specific multiple worksheets. For example if a workbook has 10 worksheets, I need to select 5 of them based on their name and copy the complete worksheets to a new workbook. Can anyone help plz?

Hi - I have a code (shown below) that is creating multiple copies of a template worksheet and number sequentially. The problem is that I would like to have the template worksheets hidden, but when I do this I get a Run Time Error 1004: Method Select of Object_Worksheet failed. If not hidden, it...

I'm working on a macro to make an exported report more useful. My intentions are to: Delete unnecessary columns make 30 new worksheets based on the names of "teams" and copy the data from the first sheet to those Now each worksheet has extra rows, delete the extra rows based on the value in the...

I have 2 workbooks "Template" and "Target". The macro will run from Target & should open "Template," copy sheet "MasterList" and paste it before the "Change Tracking" sheet in the "Target" workbook. It's important to note that the name of the Target workbook will vary by project. So I can't...

Hi there!! I've built a macro to open a file and copy one of its worksheets into a different file (both files are in Excel 97-2003 format). The macro works great when I manually select the macro from the macros dialog box and click "Run." However, I tried to assign the macro to a hotkey. Now...

I need to create mutliple workbooks that contains multiple tabs from one original workbook. There is one sheet that should be parsed by Name, the other sheets should be the same in each copy of the original workbook. So far, I have created a macro that creates workbooks by parsing the first...

I want to manually (or with VBA) copy the all of a worksheet's cell values between workbooks. The source & destination worksheets would have the same name. I tried use the "Move or Copy" option on the right-click pop-up menu. But this moves all of the source workbook range names to the...

I'm trying to copy some data to a new workbook all on one worksheet from multiple sheets in another workbook. My code keeps breaking at the point where it makes a new workbook (.SaveAs Filename). It gives runtime error 1004. I'm not sure I have the copy values set correctly either but can't test...

I have a macro that prompts the user to select several workbooks and it consolidates some data from each selected workbook into a master file (the one which the macro is run from). It copies a specific range of data from the ExportData worksheet of each of the selected workbooks. The code...

HI Guys i'm hoping one of you will be able to help me with the macro i'm trying to create as I have no idea what I am doing! I have multiple workbooks all contained in one folder which all have a sheet titled "Summary". I have another workbook which I would like to pull all the "summary"...

Hi, I've a workbook containing 2 worksheets called Data_Input and Estimate_1 respectively. I've spent quite a bit of time formatting and setting up all the relations between the two worksheets and now I want to create a third worksheet called Estimate_2. Estimate_2 will be identical to...