insert a row

"insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) values('" & strRecordID &"','"& strClassID &"','"& strClassType & "', '" & strClassName & "', '" & strTypeorder & "', '" & strCreateDate & "')" This code works, but I am trying to add a subquery to auto...

Hello, I am having an issue with inserting a row into my worksheet. I believe it's because I have two tables a few columns apart from each other. I say this because I was originally able to insert rows when there was only one table present. I have tested it and when I convert the second...

Hi all, On a specific sheet (for example "sheet ABC") in a specific workbook (for example "Workbook ABC"), I have formulas in the columns D, E, G, J and I. Is there a possibility, when inserting row(s), to automatically copy the formulas down in the inserted rows in the specific columns? Thanks!

Hi All, Just checking if anyone is able to assist me with setting up a code to add rows (based on a condition) and sum lines above. Raw data is is below. <tbody> State Store Staff Name Day Date Hours Category 1 Hours Category 2 Hours Category 3 Hours Category 4 State Store 1 Staff 1 Tuesday...

Hello VBAers, I have a list of data where I need to enter a blank row under the row of where a certain value appears in a column. <tbody> Dog Brown Charlie Cat Jack Dog Brown Princess </tbody> In the above example, every time Brown appears, I would like to enter an empty row beneath...

Hi Guys, Can you help me tweak the code below for below table? <tbody> No x 1 Sean 2 3 Output Submitted To Department 4 Output Submitted To Deparmnt 5 Output Sbmitted To Dpartment </tbody> ------------------------------------------------------------------- Sub...

Hello all. I need help with the following. I want to be able to add a checkbox to a specific Column-Cell everytime a row is inserted the checkbox should be added to the same row just on the new row that was added. so far I have found plenty of material out there helping me figure out how to...

I have been searching the internet and watching Youtube videos for days trying to create a macro in VBA that will enter a row above a specific text string in a worksheet in Excel. Every worksheet I would perform this macro on has the term "Actual Earnings" somewhere between cells A19 and A22...

I am attempting to compare lists of data and insert missing rows. The below code is intended to do so, however, if it encounters an items in the Account Master List that is not on the Execute billing list it will insert rows for everything that comes after that row of data. Any help is...

Hello Guys, I have long list of data and I want to insert a blank row after every nth row for example after. Below is the sample initial illustration. I need to add starting <tbody> A1 A2 ID Name Score A3 A4 001 BEN 5 </tbody> The data starts in A4 onwards and what I need is...

hi, i have a spreadsheet that contains lots of data and i need to add rows at various points based on cell value in column t, the problem i have is that the column contains continuous data such as below but a lot more 161000 161001 161009 170000 171253 183653 250000 260125 262545 the ranges are...

Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...

I am in desperate need of some assistance. I'm trying to teach myself VBA in Excel 2010 and am building an application for a friend. I've come to a point where I'm at a standstill until I can figure this piece out. I've posted this question a couple of times and haven't received any...

I need to show the following and I can not figure this out! Scenario 1 I have row 10 filled with data up to column O I have rows 11-24 hidden This 15 row set up is copied down 50 times so the below process would need to be repeated in each of those 15 row sets If column O has a value >0 than I...

I am processing survey data and am going through a very tedious time with transposing columns into new rows and need the VBA expertise of this group! My data looks like this (as an example): ID Are you male or female? What is your favorite color? 1 2...

Hello everyone, I've searched the forums for a suitable answer to this problem but so far with no success. I have a small worksheet with only 1701 rows of data. I need to insert a new row every 5th row. In that new row I need to populate 3 cells (D, E and F) with the same data each time, all...

Hi everyone! I have been a mrexcel user for a long time, but I registered on 2014 and I have never posted because I always found what I needed or something close that I could modify to get the results I needed. Having said that, I need your help because I can't find something close to what I...

Hi I am looking for macro help where i can insert a blank row in range of cells based on non blank cells of the above cells. For example after filling data in Range (A2:O2) completely, with a macro help i want insert a blank row down (i.e., A3:O3). Could any one help me on this.

Hi Basically, I'm trying to run code when a value is entered in range("A:A"). The code will repopulate specific cells with formulae if the user inserts a new row and enters a value into Range("A:A") I've searched for an event for INSERT ROW but this has been unsuccessful Much appreciated

Hi all, I'm trying to figure out a way to insert 4 rows, based on the value cells in a specific 1-column range. For example, for all cells in column C which equal "I need help", insert 4 rows below. Any help would be much appreciated. Thanks!!! Tony