insert row

VoG, I have a macro you supplied in a different thread: Sub InsRow() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR To 2 Step -1 If Range("A" & i).Value <> Range("A" & i - 1).Value Then Rows(i).Insert Next i End Sub However, this is inserting a row ABOVE...

Hi, I have a list of sells that is poviding, for simiplicity sake, the Following Col A - Company Name Col B = Start of year (e.g. 1/1/2007 or 1/1/208) Col C = End of Year (e.g. 12/31/2007 or 12/31/2008) Col D = Revenue for the year This goes on for a good 1500 rows. What I am trying to do is...

I am just learning Excel is there a way to have a line insert automatically when a condition is met? For example if I have column that has account numbers entered it, I would like to have a row inserted when the account number changes. Acct # 225 225 225 226 Since this changes I want a line...

Hi, I want data to populate on "sheet 2", from "sheet 1". That means that when I insert a new row in "sheet 1", I want "sheet 2" to display the data that has been entered into the newly inserted row on "sheet 1", without having to re-enter the formulas in "sheet 2". I'm fairly macro -...

Hello, I designed an employee expense report form in Excel 2003 using the list function. The form looks like a table, with 6 columns and 20 rows, and the user lists expenses in the last 3 columns. In the 20th row of the table/list, there’s an asterisk/insert row. This is handy if the user needs...

Hello! I need your help to build a macro that can do this manual and boring task for me. I have a list of information and I need to: 1 – Insert two rows every time the code in the column A changes 2 – Sort every single new interval by date (column B) and then by description (column D) 3 – Sum...

Hi guys, I'm doing a spreadsheet for different countries with numerous Reports. Whenever I insert a report for an individual country, a row will be inserted below. ActiveCell.Offset(1).EntireRow.Insert However when I enter the value for report #1 for Bangladesh in the other columns (...

Hi everyone,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I've been rummaging around the web for a macro that inserts a new row at the bottom of a table and copies over the formulas -- however due to the layout (formatting) of the sheet the...

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid...

I need to insert a blank row before a subtotal, can you help. Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(6, 7), _ Replace:=True...

Hello, I am new with macros and still trying to understand them logically. I am looking for a macro that would allow me to insert 12 rows after each original row and that it also copies or repeats all the information of each original row of a 250 row sheet. The sheet I currently have...

I have a spreadsheet for recording various financial data, at the bottom of which are subtotals [subtotal(9,range)] of some but not all columns. I've got the following Code to insert new rows, copying formulas from a hidden row at the top of the spreadsheet. A = Int(InputBox("No...

Hello everyone I was wondering if you could help me.. I am a beginner and need some help with the code I have just written. I need to alter this code in order to do 2 things 1. to leave a blank line inbwteen Shop A's Apples, Shop A's Pears etc 2. I also wanted to total up the price...

Sorry, this is a duplicate message. how do you delete it?

I am new to macros and VB, so I may be missing something basic. I am having this problem: I have a workbook with many worksheets, all of which refer back to Sheet1 such that each row on each sheet should match up (represent the same item). I created a macro to insert a row in each sheet at the...

We have a calculation sheet that exports a list of test treatments to Excel from another database. We then run a macro on it to insert formulas to calculate certain things for our lab work. There can be anywhere between 1 and 25 treatments usually. When the data exports to excel, the treatment...

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I need a code to do the following: <o:p> </o:p> The cell value on worksheet (RFQ_Mani!$E$1) changes constantly by a formula calculated <o:p> </o:p> Based on range of sequential rows selected I need a...