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

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top