insert row

  1. P

    How to insert new row with dummy info if there is no sequence to item numbers

    Hi there, I'm working on finding out missing orders in a bunch of sales records. I'm attaching a sample workbook here so that you can understand more of my requirements. Appreciate all the help you can provide. The sales invoice denotes the sales invoice number at a material level. The item...
  2. B

    VBA to complete a list with missing items

    Hello, I have two sheets: Sheet1 and Sheet2. In Sheet1 I have names (Name1, Name2, Name3...) and projects (Project1, Project2...). I mark with an x the name assigned to a project. In Sheet2 I have have the working days of the calendar and the names with their assigned projects. I would need...
  3. G

    Automatically Insert Rows in Dependent Table

    Hello, I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically...
  4. W

    Using macro button how to insert rows in two non formatted tables

    I have two unformatted tables in my excel worksheet. The tables are vertical from one another. I have successfully created a macro button that adds 1 row under the header of the first table. However, adding a row to the second table simultaneously is where I am having trouble. What I want to...
  5. D

    Macro Find Entered Value and Insert Row

    Hi, I have a cell that is populated based on a user's input (Cell E9). I would like to create a macro that will then look for the last instance of the value E9 in a set of values (E39:E4000) and insert a row below that row. It would then also paste the value currently in H9 in J of that new...
  6. C

    Excel for Mac 2011 Macro Button to create new row and autofill

    Hi everyone, I am new to VGA, but I really need to get this button to work. I have a sheet with different tables. In my second table, I have 4 rows and 2 columns. The first column says 1st, 2nd, 3rd, 4th, and the second column is blank (besides having a thick border) for the user to fill in...
  7. F

    Help with insert row and merge cells code

    Hello mrexcel Community :) I have a problem with my VBA Code in Excel, I dont speak VBA or even english :laugh: The code I have tried to create is not doing what I want it to do. When I click on the Command Button than it does not create a new Row. The result of my tryings is this one...
  8. XfortunaX

    Insert Row Depending on Cell Vale

    Hi, I have a random list of numbers in column A and I would like to sort and insert rows and titles between certain number breaks. For example: Sort column from Z to A Insert a row between 0 & 59,000 and have 0-59K in bold in the inserted row then Insert a row between 60,000 & 99,000 and...
  9. T

    How to renumber with merged cells?

    Hi all, I have a database, where in column "B" of one of the worksheets some cells are merged (by 2, 3 or more) and some are not. I want to number them in order that every single or "group-of-merged-cells" cell will have just one number. For example, 3rd + 4th are merged, 5th is single and...
  10. D

    Sub Prematurely Ending When Inserting Row

    Hello! I just started working with VBA this summer, and I have found so many answers to my questions by just searching this forum! Finally ran into a problem that I wasn't able to find a solution to by searching, and I decided to post and see if y'all could help. I am using Excel 2013 on...
  11. S

    Excel VBA code insert a row

    Hi, I have this macro by which when you click the button, a row is inserted in that spreadsheet, this is the code: Sub textbox4_click() Range("G3").EntireRow.Insert Shift:=xlDown Range("G3") = Range("G4") + 1 End Sub However what i want to do now is ONLY allow for the button, which has the...
  12. E

    How to insert a row and auto sum by item type

    How can I automatically insert a row after each item type in column A to auto sum their totals in column I? 10096 9 10366 20 10366 29 10366 23 10370 20 10370 5 10370 13 10370...
  13. E

    How to insert a row and auto sum by item type

    How can I automatically insert a row after each item type in column A to auto sum their totals in column I? 10096 9 10366 20 10366 29 10366 23 10370 20 10370 5 10370 13 10370...
  14. L

    Create copy with insert into new sheet use VBA

    Dear Master, Could you please advise I would like copy the data in the new row other sheet below is the screen shoot what should it be Sheet 1 There are date, people , and color + number https://drive.google.com/file/d/0B995E_xrlb3STzd5VG5Jd2lmdVU/view?usp=sharing Sheet 2 If color is brown...
  15. W

    Macro to copy and insert rows based on the value in a cell

    Hi, I'm trying to teach myself to write in VBA but many hours have shown this problem is way above my abilities at the moment. I have a very long list in a worksheet where column F contains one or more pipe diameter, and if there is more than one diameter for that particular line the cell...
  16. N

    Formula Help - Prevent Row from Changing when new row inserted

    Hello... I have a CountA formula, see below... =COUNTA('0 Data Summary'!B10:B108) I have a macro that creates a new client data row in row 10, and all other client data shifts down by 1. It works fine. Now, I have some formulas on Report tab that pulls this data using similar formulas like...
  17. S

    Table Issues

    I have a spreadsheet with tables, one on top of the other, with some blank rows in between. For some reason now, I am unable to insert a row anywhere in the spreadsheet. I've tried converting the tables to a range, but I get an error that there are not enough resources to complete the function...
  18. E

    Simple Macro - Insert row and fill that same row with pasted values

    Hi All, Trying to create a macro whereby i can insert a new row and then fill that exact same row with values. This is what I have so far (fills the row below, not the actual new row). Any help will be appreciated. Sub Salesperson_Inputs() Dim Inputs As Range Set Inputs = Range("B16:BL16")...
  19. F

    Simple VBA to add a row..

    I am trying to find a basic code to automatically insert a new row based on a cell value. I am using Excel 2010. To break it down further, here are the details. If any cell in the range "W5" to "W50" contains either "SP" or "TS", i want to insert a new blank row directly below whichever row...
  20. X

    Inserting copied row code causes Excel to hang (swirly blue circle)

    Hello one and all, I've inherited a Macro enabled spreadsheet I'm trying to make work on Excel 2013, it works OK on Excel 2007 and below. Problem: Manually selecting, copying and inserting a row works OK; however, when running the code below on later versions of Office it causes Excel to stop...

Some videos you may like

This Week's Hot Topics

Top