insert rows

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

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

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

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

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

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

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

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

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

I'm trying to automatically add rows to WS1 based on the number of populated rows in range F1:F20 in WS2. for example WS1 (column D) looks like: 1.1.1.3 1.1.1.4 1.1.1.5 etc. WS2 F1:F20 looks like: PM EE SW ME etc. Basically, I want to automatically add rows below each WBS item in WS1 that...

Hi there, I have a file that contains nearly 1,300 rows of data. Between each row, I want to *insert* 4 blank rows. I certainly do not want to do this manually. I have some code, but unfortunately, it just results in an endless loop that ultimately leads me to force-close Excel. Here is what I...

Column C as a code the same code may be in 5 to 50 rows before it changes I need to insert a row between the change and copy the columns A,C & F from the lower row on to the newly created row. This file as over 100,000 rows to go through. Any help would be great.

I would like to create and Userform to prompt the User to enter the number of rows needed when the Workbook is opened. I am entering data into an existing spreadsheet for work and I currently have a Macro set up to insert a row per click of a button, but I have recently figured out that a...

I'm writing code to copy rows and then insert copies of the same rows below. The numer of times it should copy and paste those rows is defined as Unit 1-7. After each for loop, I would like the code to insert a different row that sepeates each block. Please see the code below. The bold italic...

Hi everyone, I would like to ask the following: I have a table in sheet1 in excel containing 10 rows. I want to copy the first column of this table into sheet2 in the same workbook but what I want is that in case I inserted a row or more in Sheet1, I wanted to be copied to sheet2...

Hello Using Excel 2007.. I need to find a way to insert cells based on a cell value, for example if cell D2 says "4" then I need a macro that can insert that amount of rows. To make things more complicated, I will need to ensure that the macro inserts rows after the row with a specific text...

If I have a spreadsheet that sums a column of the rows above it, I obviously have to refer to the starting row/cell, say A3. I then refer to the ending row/cell, say A10. My problem is that my users will insert new rows above row 3, but my formula says start at A3. If there is a value to be...

Good Day, I am trying to find the last row with data in it, then insert a number of rows. The rows inserted will be different for the first page, then similar for every page after that. Basically if the data goes to more than one page I want to put in X rows so the table is filled on th second...

Hi, I'm new so be gentle. This is a bit complex for me so I'm completely lost. Below is an example of what I receive from our system, except imagine it about 200 columns across and up to 8,000 rows down. So manual manipulation is not only horrid but a risk of error. Column's 'A' and 'B' are...

Hi, I have a spreadsheet with around 900 rows and lots of sets of duplicates that I need to separate from each other and analyze. I need a macro to insert 3 blank rows after every set of 9 that can be identified by the text in the last row of column A which will include the words "Site 9"...