insert row

  1. X

    Inserting copied row code causes Excel to hang (swirly blue circle)

    Hello one and all, I've inherited a Macro enabled spreadsheet I'm trying to make work on Excel 2013, it works OK on Excel 2007 and below. Problem: Manually selecting, copying and inserting a row works OK; however, when running the code below on later versions of Office it causes Excel to stop...
  2. M

    Insert New Row and Autofill Current Date (Not Time) In Column I

    Hello There, I have a report in Excel and am looking to track all items by their Log Date.</SPAN> There are no dates yet in this column (I) since this is a new column added to my report. I was hoping upon inserting a new row that the Log in Date would auto fill for users with the current...
  3. Prevost

    Exit if statement when condition met

    Hi there, I am trying to make a macro to insert a row between different numbers. I would like the if statement to end if either of the first two conditions are met. I do not want to exit the entire macro though. Can someone help me please? Thanks. Sub AddRow() Dim Cell As Range For...
  4. D

    Insert multiple rows depends on cell value is getting error

    Hi Friends, I am trying to add insert rows using macro. L column fills with numbers. if L1 value is 5 then below need to insert 5 rows. I tried below Macro. But it getting Error. Please solve this and let me know whats wrong in it Sub InsertRowswork1() Dim LastNumber As Long: LastNumber =...
  5. 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>...
  6. T

    insert rows in vba based on two criteria

    hi all, i'm just a beginner with vba so please give me an explanation for the answer below. As a note, i'm looking to solve this with vba as this is part of a longer piece of code. I'm working with a table like this: <tbody> Absolute Return Description Percentage Strategy A Strategy A...
  7. D

    VBA to insert/delete rows when expand/collapse overlap pivot tables

    Please help me with code that inserts or deletes an appropriate number of rows when expanding or collapsing pivot tables that would otherwise overlap another pivot table when expanded. I have several pivot tables stacked on top of each other on one sheet, all with the same column headers...
  8. G

    filter values copy and add row and insert

    1. In "sheet1". i have to columns "A" and "B". 2. In "sheet2" for "A" column value are there with blank cells 3. if i filter one "A" column Value in "sheet1"..there will be "n" number of result we are getting. how can we get that all values under "sheet2" with insert rows? <TBODY> sheet1"a"...
  9. G

    filter values copy and add row and insert

    1. In "sheet1". i have to columns "A" and "B". 2. In "sheet2" for "A" column value are there with blank cells 3. if i filter one "A" column Value in "sheet1"..there will be "n" number of result we are getting. how can we get that all values under "sheet2" with insert rows? <TBODY> sheet1"a"...
  10. D

    Excel 2007 Button to add more rows to table

    Hello there, This is my 1st time trying to code in VBA. I have a table (with formatting) with 8 columns on sheet 1 of my workbook in Excel 2007. I have created a button that when clicked it adds 37 rows to my table (just enough to add another page for printing). Below is my code Sub...
  11. T

    Insert a row to the end of a named range if count of cells on another sheet > 30

    'So, I have a user entering items on a sheet, I have vba adding these items to another sheet where everything 'is formatted and sorted by item type (the user does not see this process) 'What I'm having trouble with is getting the code to count the items of each type, then if there are more...
  12. J

    Insert row bewteen every data set , then calcuate the differnce and populate

    Hello everyone , i m not sure if i m saying this right but here goes . i have data set of two values . For example time versus distance. For each time value there is a corresponding distance. i would like to be able have a macro that inserts a row between every time and distance point i have ...
  13. C

    Macro to insert row and copy down formulas

    My worksheet has no visible row no for user presentation. I want to place the cursor in first column (A) and at that row insert a new row from A to W and copy down all the formulas/formatting and conditional formats. Need to attack a ctrl key L to run it. This macro only to work in Cost manager...
  14. W

    Insert rows based on condition

    Hello, I can't find a solution for my problem. I need a macro to insert new rows and copy values from columns in the row ahead to the new lines. Column A is company name and Column C is text that belong to the company. Column B is number of periods, and I need it to be until 5 periods for all...
  15. B

    Find duplicate cell, insert row below, calculate VBA

    Greetings, After searching the forum, I cannot locate anything similar to this scenario, so here it is: 1. Locate duplicate part numbers (Column C). 2. When identified, insert a blank row below 3. Copy cells above blank cell in Columns A, C, D, and E 4. Concatenate the two cells above blank cell...
  16. D

    Allow insert row in to range with locked cells

    Hi All I have been trying to protect some important cells, among other things, with my excel today. Having found a fair few posts on here I have managed to protect all of the ones in want. For example columns B, C, D, E, G, H & J, Rows 2 to 20 as some contain data and some formulas. Cloumn F...
  17. G

    macro to insert row above

    Hello! Awesome Site by the way :) I need to create a macro that will do the following.... When value entered into Column A Sheet2, insert row above. The cell in column A that is now inserted should read "subtotal" (In Bold, caps) Thanks In advance!
  18. B

    Insert a new row of data whenever a cell in a colmn equals "R"

    Hi I am looking to insert a row every time any cell in column A = R This will happen around 50 times. The inserted row will need to have an R in column A and the number 349273 in column B. Any help on this would be greatly appreciated. Cheers
  19. S

    Macro Insert Row Below Copy Formulas and Formats

    Greetings, I have a spreadsheet in which we sometimes need to insert a row right in the middle of a bunch of filled-out rows. I'd like to have the inserted row contain the same formulas and conditional formats as the other rows, but not copy the text/values. I've tried a few things but...
  20. ita

    Insert a ROW of data to multiple - differently named, and located, but same structured workbooks

    Insert a ROW of data to multiple - differently named, and located, but same structured workbooks Excel 2007 Windows 7 OS Environment:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007 in a SharePoint environment with full rights and access to all...

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