copy sheet

Hello All...need some advice...I have a main.xlsm file with sheet2. I want to create a button that when i click it will save the sheet2 into separate workbook. I found the code below is useful, but when sheet2 is open and i click the button, it got error. Please help how to resolve. I want...

Good morning, I have this code below and I'm trying to tweak it to work for my situation. I'm trying to copy a sheet from a closed workbook into my current active workbook that's open. The location of the sheet/workbook I need to copy from always remains the same and the workbook I'm copying it...

good day to all! I don't know if its the lack of sleep or what! but can't seems to find the problem I'm trying to copy all records from sheet (source) to the lastrow of another sheet (target) with the following code For iLOOP = 2 To FinalRow ' METHOD 1 Worksheets("TARGET").Range("A" &...

Hello forum, I need to be able to copy a sheet into a 3D array with the first dimension being values in rows of sheet, the second dimension being values in columns of sheet and the third dimension being set by a variable(sample). I need the data for previous samples (speaking of this same code...

Hi, I nearly have this working. I want sheet 12 (called Journal) to be copied and saved into a new macro-enabled workbook. It's getting stuck at the save part, saying "The following features cannot be saved in macro-free workbooks: VB project" Sub New_Journal() Dim wb As Workbook Set...

Hello, I write next code to copy active sheet, is working but: - i need to: - switch it in ActiveSh, new created copy; - counting cell A14 start from 1. to 999. on each copy; - counting cell D16 start from 001 to 999 on each copy; - counting of sheet is not...

Need some help writing a macro that will do the following; 1. Prompt for cell selection 2. Copy a hidden "template" worksheet to the end of the sheets 3. Rename that worksheet based on the cell selection from step 1 4. Hyperlink the cell selection to the newly copied worksheet Update- I did...

Hi, I just learned how to populate combo box with the sheet names of the selected workbook. Please forgive me if I ask stupid questions, as I'm new in this. Further to my project, When a file is being selected, it's sheet's names also appears in combo box. Now, what I need is that when any of...

Hi, I am new to VBA, to be frank I am new to Excel. I needed to copy a sheet to the end of the workbook and rename with a value of cell in another sheet of the same workbook and copy some values for another sheet. I manage type some code based on the results i get in web but i am getting...

Hey Guys, This one has been allusive I am hoping one of the geniuses here can help. I have an order calculator I developed for my business, I place all my orders Monday for the week, I am having an issue where if I should change my forecasted ales during the week the value of the amount...

During the last 2 weeks I've been trying to solve a seemingly unsolvable problem: how to set up a workbook with VBA, where the VBA needs to be signed, and still have users copy sheets in it, without that copying breaking the signature. There seems to be a narrow escape route, but it's still not...

Hello I want to copy all sheets in active workbook into a new workbook except one sheet called "Main". I have written the code but it only copies the sheets that typed inside array. I have a lot of hidden sheets so will take too much time naming each one. --> I basically want to select all...

Hello I am new to VBA but did a lot of research and a lot of readings in order to create a VBA to my employer. I have written the code but having some small bugs that you guys might be helpful. Purpose of Code: When you first open my excel sheet, only three pages will be visible( Sheet 1,2 &...

Doing a daily report, in which I import 2 sheets to be processed, we'll call ClassReport and GradeData. Both have a varying number of rows, but have the same general setup each day. Say I want to pull in grade percentage for each student into Class Report, doing a vlookup referencing Grade Data...

Hi. I'm hoping for help with a code in Excel that will copy and automatically name the new sheet as 'active sheet' + 1. For example, if I am on a sheet titled "3", I would like for the new sheet to be titled "4" Thanks to MyExcel.com, I have obtained code that creates a desired quantity...

I have a workbook that gets updated daily and for each day we create a new sheet. I have a pivot table that summarizes column D (item#) and column C (quantity). when I copy the sheet the pivot table stays linked to the data on the original sheet and not the new sheet. I must be missing something...

Hello All, I have searched without success to find code I could adapt to what I want to do. I want to copy my existing worksheet (named "2014") including the command buttons and the code that goes with them, to a new worksheet (named "2015") and so on every year. And I would like this to happen...

Hi all, I have some working code that accomplishes the task but I am sure there is a more elegant solution that someone might be able to suggest. The goal is to enable a button linked to the macro so the user can click it, pick a file (an xls report of unknown name with one sheet only), and...

Hi all I have the following code but need to tweak it so that on the 2nd time it runs, it no longer creates every single sheet, but only new sheets (not yet on the workbook). Can anyone help? The purpose is to create new sheets based on sheet 'Template'. Also I'm having some trouble on the...

Hi, I've created a sheet containing some macros (see below as an example). The issue is that when I create a copy of this sheet in the same workbook, all the macros references get lost and i get the Run-time error '1004': The item with the specified name wasn't found. Is there anyway to fix...