insert a row

Hello everyone! I'm hoping there's an easy way to select individual cells besides ctrl + click. Basically, I need to select individual cells with the TRUE value to insert a row in between them. Other than manually selecting the relevant cells, the closest I've gotten is using ctrl + F to find...

I have a bit of code that has been working fine for years, but now suddenly get feedback from some users that my error catching shows them "Insert method of range class failed". The simplified version of my code is the following: Sub AddLine() On Error GoTo ErrCatch Set Sht =...

Hi all, I've only recently gotten this weird behavior out of Excel so I'm not sure what's going on. I press Ctrl+Shift+Plus and a row does not get inserted but all the formulas in the cells below the section I'm supposed to be inserting get stepped down by 1 cell. For example, if a cell below...

So I have a worksheet that has entry's for data for every day of the month. The layout repeats every 6 rows for the entire month. My goal is that when a value is entered into the last formatted cell in column E for a day then a row would be inserted below it copying the formatting of the row...

Hello again all. My brain hurts trying to figure out this one. I have a spreadsheet of all open orders, listed by date. I'm trying to find the last instance of a workday date, insert a row, format the row, and add text to the first cell. I can get the formatting part pretty easily, the tricky...

Currently using this simple "insert row and fill down" macro. I'd like to limit the fill to rows A-K of the row being copied down. Any help is appreciated, thanks! Sub InsertCopyOfPart() Application.ScreenUpdating = True Dim r As Long r = ActiveCell.Row With ActiveCell...

Hello - I'm looking for some help to create a VBA code macro. I have a report that I can export from our project/finance system that I need to manipulate a bit. This is a sample of what the raw data looks like (have of course modified some of the data for privacy) -...

Hello, i have a column as seen below and another Column as seen below I need each row from Column A to have all possible values from criteria 2 to show as follows: Can we do it using an excel tool or VBA? since i will need to do this for 300 criteria 1 and 300 criteria 2 Thank you in...

hello I have a spreadsheet created by someone else that has a lot of codes etc . It is an invoice tracker that team members are INSERTING A NEW ROW when imputing a new invoice. This is done so that the new entry will have formulas applied like the other entries. A- I need to create a onetime...

Hello, I year ago I asked this question and I got a great answer but now I need some help creating a conditional statement within the code: The code below will in its current state insert "x" amount of rows dependent on the specified "row interval." Sub InsertRowsAtIntervals() 'Updateby...

I have a line of code to trigger a macro when a cell in specified column range is selected: If Target <> "" And Not Intersect(Target, Range("D6:D1048576")) Is Nothing Then Is there a simple modification I can make so the macro will not be triggered when I insert a new row?

Hi I am creating a spreadsheet where people will fill in details for certain things, my idea is to have them add rows as they go to each of the tables within the worksheet. However, when they add rows to the first table, this now means that the insert point I chose for the following tables is...

Hey new to macros. My issue, I want my macro to loop through a number of cells on sheet1 and then transfer the entries into specific cells onto sheet2. On sheet2 column A, I want specific headings to be printed based on whether or not the values in sheetA1 are different. Visual aid: Sheet 1...

I've got a workbook with 48 used columns. Of those 48 used columns I need to select and copy a range covering the contiguous first 29 columns. I need to be able to select which row to start the range on by using an inputbox and a find/match loop until the given string is found and a cell address...

After commenting on this thread, I was advised to post a new question. I am writing a macro to insert rows in a sheet based on whether the first part of the value in colA corresponds to a certain value in an array. Initially, I had the array fill into G3:G15 as text, then the sub compared the...

I have a code that inserts an entire new row and copies the contents from above row. I was hoping to edit the code to insert a row and have it be apart of a table, not just a new row under the table. Any suggestions on how to do this? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...

Hi all, I already read some threads in this big forum but didn't find what I am looking for. I hope it is ok to ask for some help on this: I have a table and a button to click in A1. If I click this button, a new row shall be inserted below the current active cell including only the above used...

Hi all, I need to dynamically insert a row into a table based on a cell value. I'm able to insert the row, but I haven't figured out how to make it dynamic. The row will always go above the row with the value "2270PBAKE" in the STAGE column. I'm using the Table.InsertRows function. For the...

Hello, I need some help on VBA, please. I've inlcuded an short example below of what I am trying to achieve. I am trying to figure out the VBA to insert a variable number of rows (based on the value in Settings!C13) between existing rows on the worksheet 'UNIT_PRICE_COMP'. Some rows are...

I have the following code: Selection.End(xlDown).Select Selection.ListObject.ListRows.Add AlwaysInsert:=True Selection.ListObject.ListRows.Add AlwaysInsert:=True Selection.ListObject.ListRows.Add AlwaysInsert:=True Selection.ListObject.ListRows.Add AlwaysInsert:=True...