add a row

  1. B

    update workbook when row added or deleted

    Hi all, I have vba code to update the workbook when there are changes in a table. My problem is that if I add a row to the table, it calls the code and updates the workbook, but if I delete a row, nothing hapens. My code is this on: Private Sub Worksheet_Change(ByVal Target As Range)...
  2. B

    Sort 2 database separately by date and adding space in between dates that are different

    Hi, Is there a way to automatically sort 2 database's by date and add space in between dates that are different? ABCDE1Office...
  3. M

    Macro to add a new row with a checkbox

    Good afternoon, I am trying to create a macro that will insert a new row at the bottom of a table and add a checkbox to it. The goal is if a user needs to add 2 or 3 lines, they could run this macro 2 or 3 times. Thanks in advance!
  4. L

    VBA to match number of rows in a secondary table to the primary table automatically

    Hi! I've been trying for ages (not good at VBA!) to solve this with no success - I'm sure it's very simple but I'm not winning! I have a primary data table (Table1) in Sheet1 and a secondary table (Table28) on a different sheet, Sheet2. Table 28 is set up to pull through some of the...
  5. A

    Please Help with correct code

    Hi, I am trying to create a spreadsheet for a client of ours and the point is to make it easier for them to access their information in the spreadsheet. They want a button to the right of their spreadsheet, which I have already created, but I need a code to where it automatically adds a new row...
  6. D

    Loading ComboBox From a Table

    Hi All, I have a userform(DelForm) with a combobox(cbDelAssociate). I am loading the combo box with a list of names from a table on a worksheet("2015"). With this code: For x = 3 To ActiveSheet.Cells(1, 1).SpecialCells(xlLastCell).Row If ActiveSheet.Cells(x, 1) <> "" Then...
  7. L

    Adding or copying formatting of rows in protected worksheet

    I have a worksheet that has formulas in row 10. All the formulas except the first one are based on a rolling calendar year (for sick leave), and the first formula is based on a calendar year. One column also has a formula in each cell, but I left it unprotected and used data validation to let...
  8. P

    Add a new row based on criteria

    Hi, I have a sheet of around 450 rows, I would like a macro to do some manual work for me. Is it possible for a macro to insert one blank row if a "No" is present in column T. If possible I would like the row to be inserted above the “No”. Thanks
  9. J

    Macro Help. How to add row when certain value reached?

    I need help with a macro that adds a row under the following condition: From N5:N80, if any of those cells contains a 5 or higher, then add a row below that cell where you have the 5 or higher? Ex: N26 has a value of 6. Therefore I would want a row below N26. Then N55 has a 7. I want a row...

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
Back
Top