add row

  1. T

    Lock formulas in column, protect sheet, add and delete rows

    Hi, we have an Excel sheet which we send to the client for them to type in data for their employees and they're always messing around with the formulas in column G. We're trying to find a way to lock the formulas in column G, but still allow the client to add new rows by copying and pasting the...
  2. S

    Add a Row dynamically anywhere in a table besides the first row

    I want the ability to add a row anywhere in a table besides the first row (row 18) . The code I have to dynamical add a row is below. I already built in restrictions that only allow the user to add a row into a designated table. I just don't want them to add a new row to the absolute first row...
  3. S

    Add Rows Dynamically with a button in a row of data

    Hi All, I would like to build a sheet that allows users to highlight a row, click a button, and insert a new row of data after that row ( and consequently shift the data below the added row down). The sub I currently have just adds the new data to the bottom of the existing data, but I want...
  4. S

    Help with VBA code for button to add new rows with formula

    Hi, I have a code that I need help with adjusting as it almost does what I want it to do. I have added a button that quickly adds x amount of new rows from row 5 downwards. The issue is, I want them to be blank but still contain dropdowns and formula. The code I have is below, but I am unsure...
  5. J

    Userform code help - submission add row above

    Hi there guys. Building a user form currently and as it stands the data gets added to the last blank row: To achieve the last row input I've used the offset method and this target row code: "Dim TargetRow As Integer TargetRow = Sheets("engine").Range("B3").Value + 1" when clicking the submit...
  6. B

    Modify Code to Add Line Below Instead of above

    I have the code below that adds a line above the active A cell. Is there a way to change this so it adds the line below the active A cell? Sub insertRevBetween() ActiveSheet.Unprotect Dim iCountRows As Integer Dim Rng As Range iCountRows = 1 'Error Handling If iCountRows...
  7. M

    Maco: add new row, keep conditional formating and functions

    Hi all, I am trying to create a macro that adds a new row to the bottom of a table and keeps the conditional formatting and functions of the row above it. My knowledge of these types of macros is VERY limited so please be patient when asking questions. I currently have the following macro but...
  8. L

    Insert Row copy formulas but not content

    Hi, I am a bit rusty on excel and wanted to check how you would suggest I complete the below. I have a spreadsheet with various sections so for example Rows 3 to 6 are one section, rows 7 to 10 are another and 11 to 14 are another. I want to add a button to click in each section to add an...
  9. 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...
  10. C

    Macro: Add / Hide / Number Rows Based on Specific Cell Value

    Hi All, I'm looking for help on creating a sheet which will generate a blank list based on criteria input in a separate sheet. I have various macros in my sheet which have meant I can do some of what I'm looking for but not all. Separate to this one of my current macros, at times deletes all...
  11. Y

    VBA Adding copied rows after last used row

    Hi experts! I have a worksheet which always has data in the A column (as part of a merged cell). I am looking for a VBA program to help me select the last row and add a copyed set of 4 rows to add after the last row. The copyed selection will always be the same and origin from the same cells...
  12. E

    Add row when data is entered in a cell, but do not repeat it if the data is edited later

    I have a form, where I have a Worksheet_Change event which adds a new row once data is entered in a particular cell. So my form only has one row, but will keep adding rows as required. When data is entered in cell E12, it copies the current row and pastes it below it, clearing all contents but...
  13. T

    VBA - Delete or add rows based on number of merged rows in another sheet

    Hi all, I have a macro giving me headaches.. Its goal is: 1. To copy 8 columns from 'Global List' to 'Front'. Global List sheet has some merged cells and Front sheet can't have them so as to be aligned with the rest of the info already there when I copy these columns. I use this code: Sub...
  14. H

    Macro buttons to add rows to schedule

    Hi I'm new to creating macro's! I've found some code that adds a new row below a specified range and I've got this working. However the issue I have is that I have created multiple macro buttons for each sub-element of the schedule and when I click "Add Row" and a new row is added to the...
  15. A

    Add A Row Above Each Unique Value

    Hi All I have a data set like this:- <tbody> Item Category Item Sales Shoes Sports Shoes 100 Casual Shoes 200 Others Sandals 300 Slippers 400 </tbody> I want a row after each unique value in column A along with unique cell value pasted in the new row. Like the below mentioned:-...
  16. C

    Add new rows using reference cell

    I have a spreadsheet with several hundred files, each has n number of images in it. What I need to do is insert a row for every image, below the original file. So I put the number of rows to insert into the main row, and would like to use that as the reference value. Like this: <tbody>...
  17. T

    Add Lines with Total Quantity If Found

    Hello! I have lists of product information on a worksheet and I need to add Screws to an order if one of our products exists in the list on the worksheet. First, I need to find the part I am looking for in the column, sum the quantities and then add 2 rows to the last row with data...
  18. P

    Running macro when new row is added

    Hi everyone, first post here. I'm new to macros in Excel but I've done some VB coding so they make some sense to me. Here's my situation: I have an Excel sheet that is linked to a SharePoint list. (I'm using Office 2007 and had to download the Synchronize Excel and SharePoint add-in to do...
  19. R

    vlookup many - add row

    Hi guys. I have a strange excel document that I need a bit of help with: The first sheet has a user input for just one thing - a "Project Code". When this has been entered by the user, I want the sheet to auto display an "expenditure item" and "value", looked up from the second sheet in the...
  20. M

    Inserting Row

    I have a very large spreadsheet that I need to add rows to. I would think a macro would work but I am kind of new to this. In column A I have a list of account numbers when the number changes I need a new row, is there a way to do this? Column A 175X105SELK 175X105SELK 20X14KMWA70...

Some videos you may like

This Week's Hot Topics

Top