new worksheet

Hi All, Hope everyone is well, I require help with the following, I have a sheet called data, which contains data exported from a piece of equipment. I would like to breakdown this sheet into multiple sheets. I require to create a copy of sheet '1', copy A15;E46 from 'Data', paste this into...

I am in need of a VBA macro I can apply to a button to copy range E2:O100 and R2:AJ100 on work sheet titled "Historical Orders" to its own new worksheet beginning at cell A2. The new worksheet can have sheet1/2/3/etc. as a name that does not matter. This process will be repeated every few...

Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge

Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge

Hi, I'm trying to find a Macro to save the current worksheet I'm into a new workbook. For example, when the user clicks the "Save Worksheet" Macro button, it'll save the worksheet they're in to a new workbook with 1. The new workbook named with the "old sheet name" + what information is in...

Hi All, I have a workbook that has a master project worksheet page ("MAIN") that is a summary of all individual projects worksheets. On the main page I want to assign code to a button that will add a new worksheet that is a copy of a template worksheet within the same workbook ("TEMPLATE")...

Hello, I am trying to get the new worksheet I am adding to be placed after the last workbook. I want to replace the "Add" in the line: "Set Dest_Sh = ActiveWorkbook.Worksheets.Add." with "Add(After:=mainWB.Sheets(mainWB.Sheets.Count)). But, it is not working for me. Any thoughts...

Hey all! So I have some VBA that formats some data that I enter. But it formats it in the current tab. Then it messes up the tab and I cannot re-run the vba (linked to a button) without closing the spreadsheet, not saving it, then re-opening. I would like the data I put in to immediately be...

Hi All, I am trying to create a VBA script to look through an automatic generated report on one of the tabs called "All". What I need it to do is look through Column "A" and find the unique Entries and how many times these unique entries appear. Then put the results in a new tab called...

Good morning all. Hope you are all well. I have 6 Rows with the titles A1:F1 The lenth of the list will constantly change. What i would like to do is filter column C. Copy all the matching results to a new sheet with the sheets name renamed to the search criteria. I would then like it to go...

Hello - I have data in Columns A:F in my original spreadsheet and have a macro that, when executed, will copy that same data and place it in those same columns in a new worksheet. What i'm looking for is to have columns A:E be copied into the new worksheet the same as it appears in original...

I have a quotation form that have two buttons. One is click and will generate a new quote number. Another is click and it will be save with the assigned path and file name format. When I click on save File, the new saved files will also copy the buttons and macron, which I like to delete the...

I want to do a loop where you can copy say A3 worksheet 1 then add another sheet naming the work sheet "A3" then copying A3 worksheet 1 to A1 "A3". After that looping to A4 to a new work sheet naming the work sheet "A4"copying the value to A1 "A4", etc... Is there a simply way of doing this...

I apologize in advance for any noob poster mistakes - I am very novice, trying to edit an Access database. I am trying to upload .xlsx data by changing a hard-coded workbook and worksheet name to a more flexible one. The worksheet name includes a date that will be changing every time this is...

Hello together, I'm new here and I hope you can help me. I already search a lot, but I can't find any sufficient answer. I have a lot of data (over 650 rows) and every row has more than 50 columns, so I really want to seperate the data. The file is exported from a system which records many...

Hi all, I'm working with Excel 2007 and Windows XP Professional and am needing a userform that will create a new worksheet, but only if a new worksheet is needed. I am adding new accounts and we want the data sorted by month on different worksheets. What I would like is a Date textbox that the...

Hey. I'm trying to make a new worksheet with data for every change in Customer name. So, for example, the below table would represent the raw data on sheet 1. I want the macro to create a new worksheet whenever the Customer Name changes i.e. (Customer Name) =/= (Customer Name -1). I want sheet...

I have a macro that creates new sheets for me from scratch. I need a macro (Sub TOfC) to be inseted in the Private Sub Worksheet_Activate() section. Is there a way of doing this. (If it helps the Sub is in a module called TOC).I am way out of my league with this one, so any help would be...

I have a userform with 4 textbox in it, and I want the information typed in those textbox to be saved in a NEW sheet on the same workbook. For example, if I type information in those textbox, and I click the button SAVE, it will generate a new sheet and save the information there in cell B2...

I have created a "Time Clock" spreadsheet that is shared with other hourly employees in my office. I have some vba code which will copy a "template" worksheet and rename it according to the employee using the workbook. It works fine until I set the workbook to be a SHARED workbook. How can I...