insert row

  1. 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>...
  2. 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...
  3. 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...
  4. 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"...
  5. 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"...
  6. 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...
  7. 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...
  8. 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 ...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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!
  14. 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
  15. 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...
  16. 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...
  17. X

    Need Macro for Insert Row on Unique Value

    VoG, I have a macro you supplied in a different thread: Sub InsRow() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR To 2 Step -1 If Range("A" & i).Value <> Range("A" & i - 1).Value Then Rows(i).Insert Next i End Sub However, this is inserting a row ABOVE...
  18. C

    Macro - Insert 4 rows, then go to the next cell and repeat

    Hi, I have a list of sells that is poviding, for simiplicity sake, the Following Col A - Company Name Col B = Start of year (e.g. 1/1/2007 or 1/1/208) Col C = End of Year (e.g. 12/31/2007 or 12/31/2008) Col D = Revenue for the year This goes on for a good 1500 rows. What I am trying to do is...
  19. M

    Insert Row

    I am just learning Excel is there a way to have a line insert automatically when a condition is met? For example if I have column that has account numbers entered it, I would like to have a row inserted when the account number changes. Acct # 225 225 225 226 Since this changes I want a line...
  20. K

    Automatically populate data

    Hi, I want data to populate on "sheet 2", from "sheet 1". That means that when I insert a new row in "sheet 1", I want "sheet 2" to display the data that has been entered into the newly inserted row on "sheet 1", without having to re-enter the formulas in "sheet 2". I'm fairly macro -...

Some videos you may like

This Week's Hot Topics

Top