insert blank row

I need to insert a blank row if the left, 3 does not match. the code below, does not separate correctly. Application.ScreenUpdating = False Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Worksheets("doc1").Range("A2") iRow = oRng.Row iCol = oRng.Column Do ' If...

Hello, I am having some trouble with figuring out how to insert blank rows to my data set. I have been able to find information and figure out how to insert blank rows based off of one column. The problem for me is that I need to be able to do this for multiple columns where the data value...

Hi Guys, How can I insert a blank row if the entire row has zero ? Before: <tbody> Name Track1 Track2 Track3 Track4 Ben 1 1 1 2 Sam 3 4 5 6 Anna 1 0 5 9 Ted 0 0 0 0 </tbody> After: <tbody> Name Track1 Track2 Track3 Track4 Sam 3 4 5 6 Ben 1 1 1 2 Anna 1 0 5 9...

Hi Guys, I am looking for a bit of help to move some data down to a specific row across multiple worksheets. I have the text "Name" in column B, the text "Name" could be on any row from 1 to 15. There will only be 1 occurrence of the text per worksheet. I would like to insert blank rows above...

Hello I am trying to insert a new sheet row using VBA and then change the Interior.ColorIndex of specific cells in the new row. I am using ActiveCell.Offset(1).EntireRow.Insert to insert a new row below the active cell, but I am unsure how to change the background color of specific cells in...

I have run into a bit of a wall with this one...I have a list of items that were printed and a date timestamp on each line. My goal is to scan down the rows and insert 3 blank rows after each date change. I have found a way to insert a blank row after unique values. Code is below. .. Sub...

I was provided a while back with the following macro that inserts a blank row based when the contents in the first Column (A) change. I need to change it to the 3rd Column (Column C). Can anyone help me with this edit? Sub InsertRows() Dim lr As Long, i As Long lr = Cells(Rows.Count...

I am trying to solve an issue which I am struggling with greatly, and any help on it would be very much appreciated. I will try to break the issue out into steps in hope that it might be helpful. I have sheet1 that already contains information and sheet2 with information that I want to insert...

Please help; I've tried about 25 versions of different forums' code to insert a line into a table--but no luck yet. I'm just trying to have a macro that goes down a vertical list of dates in a table, starting in cell AS8, and does the following: First checks to see if the cell to the left (AR8...

Hi there, Greeting! I have very big and serious problem. I am doing the work manually and it take long time like 2-3 days. I want some function/macro whatever your solution. Problem: I would like to formula/macro look the value in front of "count" mention cell (i.e B14) and insert double...