insert a row

I have 80 excel files in a folder. The structure of each file is the same meaning beside the file name which us different, the file content is a table which is identical in all files. The files have the same amount of rows and columns. Column headers are same. Column a is the date column. Every...

I'm looking for the right code where Sheet2 will add a new row and populate the Column B cell of the new row with data from a range on Sheet1. I need this to occur every time I add new item to the range on Sheet1. So if I have: Sheet1: <code style="margin: 0px; padding: 0px; border: 0px...

Hi I have a problem that I don't think the "indirect" or "offset" function can help (I could be wrong) I have created a macro that collects market data on a daily basis and inserts a new row (Row 2) with a time stamp and all kinds of various market data in different columns. The goal of this is...

Hi, I am trying to insert a new row for each day in ascending order going down, this is for a daily process. However it works that the day goes back one each time e.g. 17, 18, 19 23, 22, 21 20. How can I make the macro insert a new line at the bottom not the same place? Cheers, Nathan

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...

Hello all, In column B I i have effective dates for different items (column A). Like so: A B 1 1/1/2011 1 1/1/2012 1 1/1/2013 2 1/1/2010 2 1/1/2011 2 1/1/2012 2 1/1/2013 3 1/1/2012 3 1/1/2013 I need to be able to find 1/1/2013 (or said specific date) in column B and insert a blank...

Hello MrExcel, I am looking for help creating a Macros in Excel. Every year I have to update rates for the next year. I have about 1200+ rows of data and about 100 items. Each item has "Effective Dates" in column B starting from 1/1/2002, then 1/1/2003 all the way up to 1/1/2014 so every 12...

I want to insert a new row with the existing formulas that I have in the current row. I want this row to be below the current row and I want it to insert when data in column A is changed from empty to a selection from a dropdown list. Can anyone help with this?

Hello People! I hope someone here can help me... I have made a macro that copies a row into a new sheet: Sheets("Datasheet").Select Range("A2").Select ActiveCell.EntireRow.Insert Shift:=xlDown Sheets("MailMerge").Select Range("A7:G7").Select Selection.Copy Sheets("Datasheet").Select...

Please help. I am trying to add a row to the last row in a named range, I have found the following code: Sub newRow() Dim target As Range Dim cell As Range Dim rowNr As Integer Set target = Range("FDrivers") If line <> -1 Then rowNr = line Else rowNr =...

Hi Team, I have two similar sheets with different formulas (reference linked). I would need macro code in order to insert row in any selected cell (dynamic) the same thing needs to be updated (inserted in this case) to another similar sheet with same reference range. Example: There are two...

We have a manual process that we want to automate. I’m hoping someone can advise on how to do this with a macro? I haven’t been successful in figuring out how to make this work. Thank you in advance for any help on this, Cindy Currently using Excel 2010 On a daily bases we receive an excel...

Need some help getting this into VBA I have searched a couple of times not found exactly what I am looking for; I have a tab called "Excluded" and another called "Reconcilation", in the excluded tab I have a pivot that has been copy/pasted special. I am trying to "counta" the number of rows and...

Hello I am trying to copy an entire row, then insert it just below (formats only), which includes two merged cells. I have tried with the method below: Rows(ActiveCell.Row).Copy Destination:=Rows(ActiveCell.Row + 1).Insert (I arrive at the row after Selection.End(xlDown).Select, as I have...

I've got to change the format of this report so each new category gets its own row and the children entities appear on the next row down. It's hierarchial. Take a look at the before/after for what I'm trying to do. I'd appriciate a macro but if theres some other solution I'm missing let me know...

My apologies for this post, but apparently I can't even figure out how to apply information that's already in the forums. I receive worksheets with two columns of data: Degrees and Distance (How far something is away at each degree of rotation) I need to interpolate the data down to half...

Using a VBA (or any other method) how can I tell excel to insert a line after each group of similar cells for example a a a b b b b c c becomes: a a a b b b b c c

Before we dive in, my knowledge of macros extends to the point where I can tweak already written codes to suit my needs. I've searched all over but this one is still throwing me for a loop (no pun intended). I'm in Excel 2010, Win7. I am trying to build a budget forecast based on revenue vs...

Hi When I attempt to insert or delete a line from my worksheet, I get an Error 13 (Incompatible type I think would be the translation to english). This is an extract from the routine (which works perfectly well when I don't need to insert a line LOL): Private Sub Worksheet_Change(ByVal Target...