insert a row

Hey guys, I normally would find my own answers by searching the forums and looking at similar questions in the past. However this is a tricky one and I do not really know where to start. I would dearly appreciate any help with my query? .... I have a spreadsheet, simplified for purposes of...

Hi everyone, This should be an easy one. I have account numbers in column G, and invoice amounts in column F. I want to Insert a new row once there is a new account number. Sub total the invoice amounts in that new row. <tbody> Invoice Account $5 11111 $5 11111 $10 11111 $20...

Hello - I am trying to write a code that looks for certain values, and when it finds the first occurrence it creates a blank row. BUT if macro is ran again, it looks for empty rows and skips or jumps the code that makes empty row. It is working in part, but the line checking for a blank row is...

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.