loop and insert

I was hoping someone would be genius enough to help with this, I would be very grateful. In Colum C of my data (les that 50 rows)- there are usually 6 items for each record. These are: BOOK CA OVER SPEC DIR TOTAL Sometimes, SPEC or DIR may be missing from a record- I would like a blank row...

I am struggling to add further functionality to my code. I would like for my code to run a loop through a range of dates, found in column "E:E", and thereby use this input into cell C2 and then perform the rest of my code - saving the file to CSV (SaveAsCSV()). The spreadsheet is such that it...

Hi all, I am new to VBA but am learning, and have had some very useful help on here previously, I think what I am looking to do should be possible, but am not sure where to start. I have a batch of 600 files in a folder and need to assign a id/reference number (starting at #1261 ) in to cell...

Hello - I'm looking for some assistance, I have roughly 5000 rows of data and I need to insert a row between each of them. Basic Statement that i'm looking to achieve is: If Cell in column A has data, (Text, number, etc) then insert row beneath. Loop until cell with out data (text, number...

Hey All, I have code that loops through excel files in a file folder and edits those files. My trouble is that the code is also editing the workbook where the code is saved. Can you take a look at this code and tell me how I can exclude my workbook from the editing loop? Private Sub...

Dear All, Please help me with a vba code to convert a particular range to an image through looping. I'm using the below code, however I'm not able to convert range into image through looping. I'm using excel and outlook 2016. Sub sendMailj() Dim TempFilePath As String Dim...

Hello everyone! So just so everyone knows, I am a VBA newb, self-taught through extremely helpful forums like these. This is my first post and haven't even set up my profile fully. Lol This request will help me and my accounting team here at my job out tremendously! So, thank you for taking...

Hello, I'm facing this problem of inserting rows in a loop. Your help are highly appreciated. Sub InsertMultipleRow() Dim i As Integer i = 6 Do While i < 100 Sheets("Sheet1").Rows("i:i").Insert Shift:=xlDown i = i + 6 Loop End Sub

Hello everyone, I need to make this code run as one. Thank you for your help. Sub InsertSaturday() Dim i As Integer i = 6 Do While i < 100 Cells(i, 3).Value = "Saturday" i = i + 6 Loop End Sub Sub InsertSunday() Dim j As Integer j = 7 Do While j < 100 Cells(j, 3).Value = "Sunday"...

Sub Testingloop() Dim endrown As String Dim ex As String Dim ez As String Dim eh As String Dim eg As String Dim el As String Dim ee As String Dim es As String Dim ef As String Dim ei As String Dim i As Integer Dim LastRowColumnA As Long: LastRowColumnA = Sheets("looping").Cells(Rows.Count...

So I will do my best to write this out. Currently, I have a VBA loop that filters a range of cells looking for a color and then stores that cell reference. After that, I loop backward through the array inserting a row above it. For i = UBound(visibleRowNumbers) To 0 Step -1...

Hi there, New to this forum and I love it! I have searched and searched but can't seem to find an answer that resolves my problem. I am using a loop in a macro that groups and subtotals columns for data categories. The data the macro is run on varies greatly in size each time, but the...

Here is a screenshot of my workbook. http://my.jetscreenshot.com/20092/20160209-nszp-274kb What I am doing now is a manual process. I am copying the above Highlighted rows and then "Inserting Copied rows" under each row that is labeled "original row" to generate the required data in rows...

I'm a novice when it comes to VBA, and I have a list of names in Excel 2013 (Running Windows 8.1) and I want to write code that will generate and include all nicknames the person might have, so that if a user enters some variation - it will still be recognized. For example Richard would have...

I want to add a loop that create worksheets with the same name on the list, if the workbook does not have the same named worksheets in a list. How would I add it on this code? Can anyone do it..? Sub DeleteSheet() Dim WS As Worksheet, SheetsToKeep As String Const SheetNameWithList As String...

Good Morning, I have created the following macro which is supposed to loop through all the data points and create Outlook calendar entries for each line of data in my Spreadsheet. At the moment it looks like it only enters the first line as an entry to Outlook before stopping. What do I need...

Please help ! I want the macro to go through all the files in a sub-folder and look-up the file names mention in the another excel sheet "Sample 1", and open and paste the "name" in "A2" and "no" in B2. "Sample 1", A B name no. Central 5656 Sustainable...

Hi, I'm using Excel 2013. I'm looking for a VB macro solution. I want to loop through all used cells in column H and enter a formula in each cell. The formula basically divides the figure in cell G with the figure in cell F. I think the formula should be ActiveCell.FormulaR1C1 =...

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 all Window 7 / excel 2010 Here comes my problem, I get workbooks full of data but not organised except for one thing the phone number is in the cell below the cell with the valuue "Phone" Currently I can retrieve each number in a sheet and create the list on the sheet 6. here is my code...