insert row

Hello one and all, I've inherited a Macro enabled spreadsheet I'm trying to make work on Excel 2013, it works OK on Excel 2007 and below. Problem: Manually selecting, copying and inserting a row works OK; however, when running the code below on later versions of Office it causes Excel to stop...

Hello There, I have a report in Excel and am looking to track all items by their Log Date.</SPAN> There are no dates yet in this column (I) since this is a new column added to my report. I was hoping upon inserting a new row that the Log in Date would auto fill for users with the current...

Hi there, I am trying to make a macro to insert a row between different numbers. I would like the if statement to end if either of the first two conditions are met. I do not want to exit the entire macro though. Can someone help me please? Thanks. Sub AddRow() Dim Cell As Range For...

Hi Friends, I am trying to add insert rows using macro. L column fills with numbers. if L1 value is 5 then below need to insert 5 rows. I tried below Macro. But it getting Error. Please solve this and let me know whats wrong in it Sub InsertRowswork1() Dim LastNumber As Long: LastNumber =...

I have a spreadsheet with several hundred files, each has n number of images in it. What I need to do is insert a row for every image, below the original file. So I put the number of rows to insert into the main row, and would like to use that as the reference value. Like this: <tbody>...

hi all, i'm just a beginner with vba so please give me an explanation for the answer below. As a note, i'm looking to solve this with vba as this is part of a longer piece of code. I'm working with a table like this: <tbody> Absolute Return Description Percentage Strategy A Strategy A...

Please help me with code that inserts or deletes an appropriate number of rows when expanding or collapsing pivot tables that would otherwise overlap another pivot table when expanded. I have several pivot tables stacked on top of each other on one sheet, all with the same column headers...

1. In "sheet1". i have to columns "A" and "B". 2. In "sheet2" for "A" column value are there with blank cells 3. if i filter one "A" column Value in "sheet1"..there will be "n" number of result we are getting. how can we get that all values under "sheet2" with insert rows? <TBODY> sheet1"a"...

1. In "sheet1". i have to columns "A" and "B". 2. In "sheet2" for "A" column value are there with blank cells 3. if i filter one "A" column Value in "sheet1"..there will be "n" number of result we are getting. how can we get that all values under "sheet2" with insert rows? <TBODY> sheet1"a"...

Hello there, This is my 1st time trying to code in VBA. I have a table (with formatting) with 8 columns on sheet 1 of my workbook in Excel 2007. I have created a button that when clicked it adds 37 rows to my table (just enough to add another page for printing). Below is my code Sub...

'So, I have a user entering items on a sheet, I have vba adding these items to another sheet where everything 'is formatted and sorted by item type (the user does not see this process) 'What I'm having trouble with is getting the code to count the items of each type, then if there are more...

Hello everyone , i m not sure if i m saying this right but here goes . i have data set of two values . For example time versus distance. For each time value there is a corresponding distance. i would like to be able have a macro that inserts a row between every time and distance point i have ...

My worksheet has no visible row no for user presentation. I want to place the cursor in first column (A) and at that row insert a new row from A to W and copy down all the formulas/formatting and conditional formats. Need to attack a ctrl key L to run it. This macro only to work in Cost manager...

Hello, I can't find a solution for my problem. I need a macro to insert new rows and copy values from columns in the row ahead to the new lines. Column A is company name and Column C is text that belong to the company. Column B is number of periods, and I need it to be until 5 periods for all...

Greetings, After searching the forum, I cannot locate anything similar to this scenario, so here it is: 1. Locate duplicate part numbers (Column C). 2. When identified, insert a blank row below 3. Copy cells above blank cell in Columns A, C, D, and E 4. Concatenate the two cells above blank cell...

Hi All I have been trying to protect some important cells, among other things, with my excel today. Having found a fair few posts on here I have managed to protect all of the ones in want. For example columns B, C, D, E, G, H & J, Rows 2 to 20 as some contain data and some formulas. Cloumn F...

Hello! Awesome Site by the way :) I need to create a macro that will do the following.... When value entered into Column A Sheet2, insert row above. The cell in column A that is now inserted should read "subtotal" (In Bold, caps) Thanks In advance!

Hi I am looking to insert a row every time any cell in column A = R This will happen around 50 times. The inserted row will need to have an R in column A and the number 349273 in column B. Any help on this would be greatly appreciated. Cheers

Greetings, I have a spreadsheet in which we sometimes need to insert a row right in the middle of a bunch of filled-out rows. I'd like to have the inserted row contain the same formulas and conditional formats as the other rows, but not copy the text/values. I've tried a few things but...

Insert a ROW of data to multiple - differently named, and located, but same structured workbooks Excel 2007 Windows 7 OS Environment:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007 in a SharePoint environment with full rights and access to all...