adding rows

  1. H

    Adding data validation to existing table - not replcating on adding new row

    I am having problems adding data validation to an existing transaction table (some 200+ rows), as the custom formula validation does not get replicated when a new line is added. In this case it is to give a warning if the transaction date is not +/-30 days from the current date...
  2. C

    VBA Code to insert rows receiving an error

    Hello, I am using a macro that imports data from a third party source via a txt file. The data is then split into new worksheets based on an ID number. (The number of spreadsheets created will vary per run). This part of the macro runs perfectly. The issue I am having is when the macro tries...
  3. H

    Automatically include added rows in complex formula?

    Hi all, Hoping someone can answer this question for me. I have a dashboard on one tab and a raw data sheet on the other. The dashboard has COUNTIFS() formulas pulling data from the raw data sheet, but my issue arises from when I add rows to raw data sheet and the COUNTIFS() do not include these...
  4. B

    Cell references when inserting and deleting rows

    Hi all! I'm relatively new to more advanced Excel functions, so this question may be relatively easy to answer. I have a spreadsheet with a list of employees that is copy and pasted for every month of the year. As of now, the spreadsheet only goes through June. There are four columns, employee...
  5. V

    Code that adds a row in a defined range in the same location as another sheet

    I have a data entry area that is a defined range ("Data_Entry_Defined_Range") on a sheet called Data Entry Sheet that allows users to input data which then feeds over to a separate sheet (Report Sheet) with a defined range called ("Report_Defined_Range"). The report sheet is used to provide a...
  6. D

    Rewritten Post of Adding Macros for Adding Rows

    My original Post was apparently confusing those trying to help me figure out this dilemma, so I am reposting a more broken down version of the post I'm new to registering to this site but have used the related posts on the forums before but I can't seem to find something more specific to my...
  7. W

    Adding userform textbox to last row + 1 of named range

    Hi all, Being new to VBA I have spent the last few days trying to name 43 columns of my spreadsheet as ranges then adding data to the lastrow. I nearly posted yesterday looking for the entire code, but with a fresh head today I decided to have another stab, utilising a "Teach VBA App" on the...
  8. C

    VBA Code to copy formula from above row, already have macro to add row

    Hi, My macro inserts a row but I am finding that not all of the formulas are on the new row. The line above and below the inserted line have the formulas in the cells. The data validation cells in the new row work fine with the current macro, it is only my sumif formulas that do not appear to...
  9. J

    Macro Help. How to add row when certain value reached?

    I need help with a macro that adds a row under the following condition: From N5:N80, if any of those cells contains a 5 or higher, then add a row below that cell where you have the 5 or higher? Ex: N26 has a value of 6. Therefore I would want a row below N26. Then N55 has a 7. I want a row...
  10. llenza

    Excel VBA: Coding issues for Looping and Adding rows with Titles

    Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...
  11. llenza

    Excel VBA: Coding issues for Looping and Adding rows with Titles

    Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...
  12. K

    Tables in Excel

    Hi there, I have created a table in excel but want a macro to be able to add another row to the table, and also one to add another column. Could anyone assist me with this, or point me to a resource that can? Im quite a newby with using VBA and havent got much experience using tables. Regards K
  13. J

    VBA code for adding one row between each existing row

    I have a need similar to the one in this post: http://www.mrexcel.com/forum/showthread.php?t=483690&highlight=adding+rows+VBA VoG's code was: Sub InsRows() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR - 1 To 3 Step -2 Rows(i).Resize(2).Insert Next i End...
  14. S

    Stumped on macro to add rows

    I really don't know what to make of this... I have a list of thousands of dates and times in chronological order. Here is a short example: 9/14/09 15:08:00 9/14/09 15:09:00 9/14/09 15:12:00 9/14/09 15:13:00 9/14/09 15:15:00 9/15/09 9:09:00 9/15/09 9:10:00 9/15/09 9:11:00 9/15/09 9:13:00...
  15. J

    Add Rows at Specific Points

    Please see the below image of a spreadsheet i'm working on. There's roughly 4000 rows of data and if there's not a quick fix with VBA then i'm going to be spending hours manually adding rows. Column B houses the Group Code, what I need to do is add 2 blank rows between each group code making...

Some videos you may like

This Week's Hot Topics

Top