new worksheet

  1. T

    VBA - Copy Range - New Sheet - Paste in new Sheet - Continue

    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...
  2. D

    In need of VBA that copies a range and pastes on new worksheet in the workbook

    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...
  3. S

    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

    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
  4. S

    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

    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
  5. S

    VBA Code - Save Worksheet as New Workbook with Certain Name

    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...
  6. S

    Creating new sheet in workbook that is the same as an active sheet

    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")...
  7. J

    Add New Worksheet after the Last Worksheet

    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...
  8. I

    Getting VBA to output formatted data in different excel worksheet

    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...
  9. Z

    Find Unique Entries in a Column and Count how many times they occur

    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...
  10. C

    Auto Filter, Copy to new Sheet with filter name paste results

    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...
  11. B

    Shifting last column in a range of data to a new column in a new spreadsheet

    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...
  12. S

    save file, delete the assigned button on new saved worksheet

    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...
  13. K

    Copying cells from one sheet to multiple sheet and naming the sheet as the copy text.

    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...
  14. K

    Line not executable on Sheets.New.Name (very novice)

    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...
  15. J

    Create out of one sheet (month) , 4 or 5 new sheets (weeks). How to do that?

    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...
  16. J

    Need Userform to create new worksheet

    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...
  17. J

    Add a new worksheet containing data if cell =/= cell-1

    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...
  18. R

    Insert Macro when new worksheet is created

    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...
  19. E

    Capture Data Entered in textboxes into New Worksheet

    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...
  20. M

    Copy and Rename worksheet in Shared workbook

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top