copy worksheet

Hello, I am trying to come up with a function or a VBA macro that is able to automatically update a cell with the next days date (based off previous worksheet) on the newly copied shoot Example: make a copy of the current worksheet (Sept 8), but the date in cell B1 updates incrementally to Sept...

I'm working on a template that allows me to repeatedly copy the initial worksheet (e.g. sheet 1) and have multiple worksheets in a single file. I do repetitive data entry/manipulation and a system like this is key. I have a variety of macros I use for this workbook, some assigned to buttons and...

I'm working with Excel Office 365. (windows 10) I've been asked to streamline a scheduling process using Excel. Once the schedule is complete that "sheet" will need to be sent to employees and client. Here's what I would like to do... 1. Create a workbook with 3 "sheets": Requirements...

I am completely new to VBA. I know only enough to copy paste and make simple edits to existing code. I have some code that I have used in the past on less complicated reports. When I try to use it now, I see that it is cycling through/opening the files in the folder, and it creates the new...

Hi, I'm new to this site and VBA. I came across solution that works fine for me up to the point where I add new items to the list and then Macro tries to overwrite sheets that are already there returning error about the name being taken... what I have now: I have workbook with sheets "List"...

Seems this should be easy, but I need some help. Two VBA statements. First sends execution to a function in the module, though it should only clear a range. IF I comment that out, second statement sends execution to a different function in the module. What can I be doing wrong? Sub...

I have a workbook with worksheets that include hundreds of rows and dozens of columns, fully formatted with borders, colors, formulas etc. The sheet contains both static areas and areas where users input information. What I want to know is there a way to take a sheet and copy (for lack of a...

I have a bit of code that I have used Sub Copy_sh() Dim SDrv As String Dim DDrv As String Dim Sfname As String Dim Dfname As String Dim wkbSrc As Workbook Dim wkbDst As Workbook Dim strFName As String strFName = Sheet1.Range("A1").Value Workbooks.Open...

No idea what changed, but now this gets stuck at the Copy after line. Throws Runtime Error 13: Type Mismatch. Could someone let me know WHY and help me fix it??? Thanks in advance. : Sub OpenCopyOrange() '////Sub 1//////'////Sub 1//////'////Sub 1////// Application.ScreenUpdating = False...

New riddle with my copy-worksheet routine: I'm copying in a daily report from a separate workbook into my processing workbook. My brain thinks that this should put it at the end, after all the other sheets. However, this isn't happening. Why? Sub OpenCopyApple () Dim tempfiletocopy As Variant...

Gaaah! Working on a macro to copy in a sheet from a daily report, into my "processing" workbook. The daily report worksheet to-be-copied will always be called "orange", so I figured when I copy it, I'll rename it "orange" + the number of sheets in the workbook (orange5 when sheets.count=5...

I have a large workbook with numerous worksheets. It contains many macros. I needed to update a particular worksheet (no macros in that one) but, because I didn't want to risk upsetting the existing workbook, I copied the worksheet to a new workbook. Having updated the worksheet, and developed...

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've not had much experience with VBA code, other than recording macros and editing them a little. What i would like to do is code a macro to copy the data (text only) of a whole worksheet into a blank worksheet in a different workbook, effectively allowing the user to "upload" the data...

Hello there, I was fortunate enough to find this code written by Joe4 which I customized just sligtly. But I am unable to save using .xlsm format. Any ideas? Saving .xlsx works fine. Thanks Sub Copy2_NewWB() Dim mySourceWB As Workbook Dim mySourceSheet As Worksheet Dim...

Hi all, I have a macro that is no longer working. I had been using this for weeks, no problems at all. All of a sudden, the macro is not working, bringing up a "Code execution has been interrupted" error. I have the option to "continue" on that warning, and if I do the warning pops up 2 more...

Hi, The following code copies an existing worksheet: QNSheet = "QN " & Application.UserName With Sheets("Quick Notes") .Copy After:=Sheets(Sheets.Count) End With What I need to do is rename the copied worksheet to the value in QNSheet. I tried using a variation of...

I have a master workbook that needs to reach out to the most recent workbook in multiple different sub directories, as listed out in column C on Sheet 8 in the master, and copy the "Comprehensive" worksheet onto a new worksheet within the master work book. So far I have gotten the below code to...

Hi All, this one is really doing my nut in. I have a brief piece of code to loop though a folder of workbooks and copy each sheet into a new workbook, consolidating them. I apply no formatting or anything, just like a straight right click > move/Copy. But when I copy with worksheet, certain...

I am using the following formula to display the first 7 characters of a worksheet name in a cell. =LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256),7) It works perfectly. However, when I copy the worksheet, move it it a new workbook and save the workbook with a name that is...