insert rows

  1. L

    Insert rows in table with protected/locked columns with formulae

    Hi all! I have a tablein Excel in which some columns need to be locked, and other columns need to beunlocked so people can enter data there. The columns that need to stay lockedhave formulae in each cell which use data that is entered in the unlockedcolumns. Peopleusing the table should be able...
  2. E

    Insert fixed number of rows and transpose part of the columns

    Hello Gurus, Seeking your expert help in writing a Macro. Am a newbie. I have a below table: <colgroup><col><col><col><col><col><col span="6"></colgroup><tbody> Sold On Mon Tues Wed Thu Fri Sat Sun Item 1 Apple 10 20 30 40 50 60 70 2 Banana 11 12 13 14...
  3. K

    Adding rows based on Criteria and populating with the data ?

    Hi guys Im completely confused and have no idea how to resolve my issue. I have a workbook with 50 tabs. I have a macro to join all tabs into a single output file, this contains start and end times. I have a breakdown of hours formula that I use so a 12 hour shift is broken down into the...
  4. J

    Copying above row formatting and formula to new row using command button

    Hello VBA Gurus, I would like to create a new row with a command button and then have VBA codes copy the formatting and certain formulas from the row above into the newly inserted row. I would like to only copy formulas from certain column ranges (i.e. A:B; D:L, U:AA) and leave the rest blank...
  5. A

    VBA macro to insert multiple rows using input box

    I have a bit of a mess here. Still learning VBA, so rather than continuing to flounder, I decided to post my code thusfar. By clicking a button on a different sheet, I need to find the cell in Col A of sheet “2018” with value “after last entry”. Upon finding that cell, I’d like to insert a...
  6. G

    Check Boxes - Auto Insert when inserting new row

    I have check boxes in one column on a form. When the user inserts a row I want the check box to populate as well in that new row in the same column as where the others are now. Is there a way to do that? Side Note: I already have a conditional formatting formula to shade alternate rows when...
  7. D

    Inserting blank rows between data, but ignoring hidden rows

    Good morning forum, I am tiring to insert blank rows between a range of rows, but need it to skip over hidden rows. Below is what I have started with and the inserting is working fine. Thanks in advance. Sub Insert_BlankRows() Dim MyRange As Range Dim iCounter As Long Set MyRange...
  8. Y

    Copy selected cells, paste with inserted rows

    :)Hi Group I have been researching for days and trying different things to get a copy and paste to work. I could really use a little help from the gurus. In the attached picture, the ideal scenario would be if the cells R2:V27 is True than copy to E28:I35 AND if the row count is greater than 8...
  9. D

    Macro to insert 'n' rows when column value changes

    Hi, I have some sheets I need to seperate the data so that when column a changes value rows are inserted. So for example if column a is: Aa Aa Aa Bb Bb Cc Cc Cc Cc Cc Dd Then the macro would insert different numbers of row beneath each value change such that each first new value would...
  10. J

    Issue with Array Formula Technique - Extract Unique List with VBA

    Hello, I am trying to find a better way to accomplish this task. I have a template worksheet that is copied multiple times (renames copies "Labor BOE X of N), then a "template table" is copied/pasted to each new sheet multiple times. There are array formulas in the first row of this "template...
  11. J

    Insert Rows and Drag Formulas Down on Multiple Sheets - VBA

    Hello, I am attempting to get my code to loop through all worksheets that begin with "Labor BOE", find all numbers in column A (beginning in row 2), insert that many rows below the cell with the number, and then drag the formulas down. For example, if cell A10 = 3, then I need 3 rows to be...
  12. J

    Loop through multiple sheets - Run-time error '13': Type mismatch

    Hello, I am receiving a "Run-time error '13': Type mismatch" when I adjusted my code to loop through all worksheets beginning with "Labor BOE" instead of just the specific worksheet I was working on. Does anyone have any thoughts on why this is occurring and how to fix it? The goal of the code...
  13. asokaw

    Enter rows automatically by accepting a number

    Hi I need to accept a number to cell A1 & insert that number of rows to a set of data already typed need to extend this feature to all the cells in that row Assume I have already entered data for rows 2 - 20 & when I enter 3 in cell A1 it should insert 3 new blank rows before row 2. & another...
  14. asokaw

    Need to add rows when a number is entered

    Hi I need to accept a number to cell A1 & insert that number of rows to a set of data already typed Assume I have already entered data for rows 2 - 20 & when I enter 3 in cell A1 it should insert 3 new blank rows before row 2. Need a simple macro to do this
  15. F

    VBA automatic row insertion

    Hello all! After a few years of following posts I've finally come across a problem that I can't solve without some bespoke help. So, here goes my first post :) I came across some code which has helped me insert a single row above when a cell value is 0. Here it is: <code>Sub BlankLine()...
  16. C

    Macro to Insert Rows (with line numbers) using Command Button

    HELP!!! I am needing a Macro to insert 12 lines at a time with the same formatting and consecutive line numbers upon clicking the "Add Lines" Command Button. Also, I only want the Macro to run if the current lines in Column B are all filled. (Also need it to move the command button to the...
  17. R

    VBA Code to Insert Rows Based on Cell Value

    Hello, I am a VBA beginner and looking to write a code to insert x number of roles based on every time the value of a cell in Sheet1 Column B is not "100" or blank, and count of an ID number in Sheet2 column A (minus 1). Further explanation below. Example Data Sheet1 <tbody> Column A...
  18. S

    Array Formulas fail when inserting a new Row

    Hi I've used this forum as a knowledge base for a while now however this is my first post so I'll try to include enough information. I've created a spreadsheet that reports weekly information for my company on tab#1 whereupon the data input from the end of each week is entered on tab#2 and all...
  19. E

    Copying duplicate rows down

    Hello everyone, i hope someone can help me out; i put the question in the excelsheet, but here a summary; With vlookup i gathered some results from other worksheets. There is a column called "Firm" with a standard value "3000" Now i need to do the following; for every row i found results...
  20. L

    Tricky macro split data and insert lines then formulas

    Hello, I have an issue with a macro I was given. It's basically crap/unusable so I'd like to start fresh. Considering that others will have to use this macro as well I need to add some prompts to ensure that they don't mess up. Here's what the data looks like 1-01-01+ 1-01-02/03+ 1-01-04-...

Some videos you may like

This Week's Hot Topics