insert rows

  1. M

    Inserting blank rows between different series of data

    I would like to know how can i insert a blank row in between ACC# when ever a new series of data begins name Acc # Balance Date John 2222 200 june 2013 John 2222 344 june 2013 John 2222 700 Sept 2013 Silva 4444 333 June 2013 Silva...
  2. M

    Insert row everytime a cell value changes

    Good morning,I am trying to write a VBA script that inserts a row every time a cell value changes. The number of rows that contain cell value A, for example, is a dynamic number (e.g. there's no set number of rows). Below is my code:myrows = WorksheetFunction.CountA(ws1.Range("A:A"))For i = 2 To...
  3. cgeorge4

    MACRO PROBLEM: How to Insert 5 Rows Above Header Row on All Sheets, Except One

    Excel 2007 and 2010 Windows 7 This should be easy for me but it's not working. 1) I have a workbook with a Master tab named "pivot sequence". 2) The other sheets in this same workbook have different names - and their header titles are all on row 1. I need to insert 5 blank rows above the...
  4. N

    Macro: If cell contains value, then insert rows, based on cell value in a column

    Hey All I'm am trying to figure out a macro to run that: If cell on Column B (let's say B5) equals "1" "2" or "3" Then insert (below) the the number of rows that the cell in F5 equals So, if "1" shows up in cell B5, and if F5 equals 3, then 3 blank rows would be added below row 5 Then, go...
  5. S

    Copy and Insert Rows - Use Dynamic Range and Paste to First Blank

    Hello, Am currently an intern and a VBA newbie. Looking to write a code that inserts rows from one master template sheet and enters them into another interview sheet. The template may change and this process needs to be repeated a certain number of times. (this number is set of certain cells...
  6. A

    Insert Lines in a range, then move data into the inserted line

    Hello, I need to do two things, can be two seperate macro's. 1. I need to insert a blank row every other row in a selected range. 2. Then I need to move the data from Column G into column B in the newly created rows. The number of rows I have varies each month. Sample is I have 80 rows of...
  7. W

    protected worksheet

    I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task...
  8. T

    VBA - Copying from hidden worksheet and inserting rows/pasting in seperate worksheet

    I have a hidden worksheet ("RawDataSheet") that pulls from a database, on which column "O" contains the month, i.e. August, September, etc., but not necessarily ALL months. I've written a short macro that finds the distinct months in "O" and copies/pastes them into another worksheet...
  9. E

    VBA - Issues with code to insert row depending on cell value, then move down

    <tbody> columnA aaa columnB 1 bbb 0 ccc 0 ddd 0 eee 4 fgh 2 </tbody> Hi there, am trying to write a code so rows are ( or not ) inserted depending on the value of the cell. If cell value is 0 or 1, there shoulb be zero row inserted. if cell value is 2 or greater, there should be 2...
  10. P

    Macro to create an "expanding table"

    So I have recorded a macro that filters for certain criteria in a master list of projects, then copies the projects that meets this criteria and pastes it into a timeline in another worksheet. However, because the list of projects gets bigger and smaller when the filter criteria changes, right...
  11. E

    inserting multiple rows after nth rows

    I am trying to insert 6 blank rows after every 6 rows of data using a macro. I have this code but it just inserts 1 blank row every 6 rows of data. Sub Insert7thRow() Dim rCell As Range, l As Long For Each rCell In Selection l = l + 1 If l Mod 7 = 0 Then rCell.EntireRow.Insert Next...
  12. A

    VBA Copy Row and Paste as Formulas "X" number of times

    I have been kindly supplied with the following code that allows the Document User to define the number of rows to be inserted in a Worksheet. Currently this code copies row 3 and pastes it the defined number of times beneath the last used row. However I would like to tweak the code so that...
  13. A

    Insert "X" number of Rows Based on User Input

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o:p></o:p> <o:p> </o:p>...
  14. A

    Insert Copied Rows every 40 lines

    Hi All, I have searched but was unable to find what I was looking for. I have a set of rows that I have copied in an Excel table. I then want to insert these copied rows every 40 lines but with a user input box that lets you choose which row to start at. For instance user can input row 45 and...
  15. C

    excel insert rows and paste incremental value

    I need to insert a random number of rows in excel and fill the cell value incrementally by one on each row. I found the following formula that inserts the blanks rows and copies the value to each row. I want the value to increment by 1 for each new row. It prompts the user for the number of...
  16. J

    Inserting rows above formula: how to?

    Hi, I'm a dunce in Excel, but actually managed to insert an "average" formula, though would like to add more data above it, to average more cells. If this is answered in another thread/post here, feel free to send me its link. I was unable to find it. I saw something on another site talking...
  17. A

    VBA Help inserting client specified number of rows and copy and paste from Row 5

    I have a worksheet which contains formulas and validations in Row 5. If a user needs to insert rows, I'd like to prompt them to ask them "how many rows would you like to insert?" and then insert the requested number of rows below Row 5. I would then like to copy all of Row 5 and paste into the...
  18. R

    Inserting rows based on cell value and copying modified content

    I must admit I don’t know how to write macros in Excel so I wonder if someone can help. I have the dataset that looks something like that: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Column A Column B Column C...
  19. E

    insert a row when the data in a column changes

    Forgive me if I don't know what I'm talking about, I'm a newbie to Excel macros. I have a large spreadsheet with over 2,800 rows and 66 columns. The data is sorted thusly: Column A (major), column B, Column D (minor). I would like to have a macro that inserts 1 row when the data in column B...
  20. H

    Adding rows between lots of numbers

    I have a column A1-A1000 of numbers. What is the fastest and easiest way to insert 3 rows between each number. Currently ... 1001 665 426 etc I want ... 1001 665 426 Thanks

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