insert a row

Option Explicit Sub InsertRowBelowNegativeEntriesInFGHI() Dim lLastColRow As Long Dim lLastRow As Long Dim lColIndex As Long Dim lRowIndex As Long Dim bInsert As Boolean Dim bIsBalanceRow As Boolean Dim...

Hi All, I need a VBA to insert a copy of row 1 above cells that are not blank based on column A2<. Row 1 is my header A1:L1. Any ideas will be great.

Hello all, I'm having an issue, which I found is quite common (nevertheless, I haven't found an answer for it). Basically, I'm trying to add new rows (5 new rows, to be specific) on top of a table I previously created and formatted. When I try to insert new rows, Excel crashes and gives me...

In Sheet1 I have case-specific data (A is sitenumber, B is sitetypes that are present in the specific sitenumber): A - B - C 1 - 1H31 - ... 1 - 1H71 - ... 1 - 1H93 - ... 2 - 2H34 - ... Sheet2 contains general data about all sites, including the species that live there. Multiple species can...

HI, I have received very two lists of contact information that have been combined into one sheet as seen below. I have broken this down into a smaller sample size because each list contaions over 5,000 rows and 20 columns wide. My question is.... Is there a way to sort the list below by...

Hi everyone, Wondered if anyone could be of assistance. I am using the code below to insert a new row below the one in which the button is located (i.e. A16). Private Sub CommandButton1_Click() Sheets("Sheet1").Range("A17").Select ActiveCell.EntireRow.Insert Shift:=xlDown...

How do I create a macro that generates a new row with pre-populated formulas in each cell? I actually only need to populate cloumns A through C in the new row(s). I'll need multiple macros as well, so the line where the row(s) are inserted will move if one or more rows had been inserted...

Really stumped here. I just recently switched to Excel 2013 and some of my favorite macros are now generating errors. The odd part is that the macro will work perfectly when I first open my workbook, but if I make ANY changes to the table at all, then attempt to run the macro again, I receive...

Below is an example of a text based spreadsheet we use for cross referencing valid cost codes. I am trying to eliminate the Write-in range of numbers and assign actual rows for each of those numbers so they can be used in a look up table. I added column F as LEFT formula and Column H as a...

I want to insert a blank row above each colored cell when in a column Under column A I have 5268 records I want to insert a blank row above a cell that is highlighted yellow. I want to do it till the last value under that column. Can someone tell me please how to write a vba for? Thank you...

Hi all, I want to know if you can help me out. The data I have is below: <tbody> A B C D E 100020265 -7,671,860.08 7,671,860.08 472023645 100020371 -6,302,466.47 7,671,860.08 472023731 100020370 -2,972,991.07 1,838,071.62 472021113 6200080166 -1,838,071.62 </tbody> I would...

Hi guys! I have a problem! I have a cell with a number and I need to insert in a table that number of rows. If I have 5, I want to tell excel to introduce 5 rows, if I have 2 I want to tell excel to introduce 2. How can I do that with VBA and Excel? For example: <tbody> A B C D E F G...

Hi, I have 2 spreadsheets. I want the information contained in the first spreadsheet inserted as new rows in the second spreadsheet where a certain condition is met. The added complexity to this is the first spreadsheet may have more than one row to add to the second row. An example is this...

Hello folks, I really need to learn VBA among other things...any help you can provide here would be terribly appreciated. I have 40 sheets that have unique IDs (1,2,3,4,5) in column "A" but the IDs (of course) have a different starting row on each page, thankfully their order on each sheet is...

Hi All I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters. Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The...

I'm an advanced user of Excel yet have a minimal understanding of vba coding. I have looked through the forum and can only find vba coding related to inserting copied rows into new worksheets as opposed to inserting them into the same worksheet. I need some vba code to allow the contents of a...

I need to create VBA that will insert & copy current row if value in column D>0 & do this all the the way to the end. I need VBA that will work as VLOOKUP but for multilines. Let's say A7="Paris" Sheet1. I need to copy a all values (if A7="Paris") from sheet2 column B, C, D etc.

I have 80 excel files in a folder. The structure of each file is the same meaning beside the file name which us different, the file content is a table which is identical in all files. The files have the same amount of rows and columns. Column headers are same. Column a is the date column. Every...

I'm looking for the right code where Sheet2 will add a new row and populate the Column B cell of the new row with data from a range on Sheet1. I need this to occur every time I add new item to the range on Sheet1. So if I have: Sheet1: <code style="margin: 0px; padding: 0px; border: 0px...

Hi I have a problem that I don't think the "indirect" or "offset" function can help (I could be wrong) I have created a macro that collects market data on a daily basis and inserts a new row (Row 2) with a time stamp and all kinds of various market data in different columns. The goal of this is...