add a row

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

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

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!

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

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

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

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

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

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