vba - loop

Good morning and thanks in advance for your help. A little information on what I'm trying to accomplish first. I have a reports where the cost center name is located in the title in cell $A$3 as "00-100 G&A". Throughout the remaining rows in column A the cost center name is repeated as...

Group, I'm working in Macro that I didn't write. This Macro was written to do run its commands one selection at a time (the selections are made via a drop-down box). I need to modify this to loop these selections so that all will run automatically one after another. It's easy to read the...

Hello all and thank you for looking. I have a userform that is intended to allow the user to apply job overages into other jobs that are not over budget. I have an Excel userform with five text boxes that are populated as follows. The user selects a single entry in a listbox (lbxOne) that has...

Hello all and thanks in advance for the help. Hopefully some of you more seasoned excel users can give some suggestions for this one: <tbody> DATE AMT 2/25/16 $50 3/4/16 $100 3/7/16 $300 3/16/16 $500 3/21/16 $300 3/21/16 $300 3/23/16 $300 </tbody> I need to...

Hey, THanks in advance. I am working on a model that copies a 10x7 table from sheet 1 to sheet 2. In sheet 2 the calculations are carried out and the results are copied into sheet 3. I want to do this n number times. The code I have written so far is able to do the first half of the job...

Hello, I am a very beginner in VBA and need to convert lots of unix files to windows file on windows computer. I could do it in Command Prompt by TYPE input_filepath & filename |SORT > output_filepath &filename . I am wondering if I can do it in VBA writing a loop? Any suggestion...

I'm trying to create a looped script that changes the value of one cell, saving it as a PDF after each change, until that cell equals the value of another cell. As an added degree of difficulty, I then want to attach all the PDF files to an outgoing email. To add a little more detail to my...

Hi, I am looking for a way to loop a macro for the code below so that I can open an undetermined number of files, copy the information and close the files. The code below opens the first file selected and copies all the data, then the other files are opened and only copy the data and not the...

We have an excel file with data in it, and we are wanting to display a "Dashboard" at multiple shop computers to view real time progress deriving from one excel file. My angle was to create a shared dashboard file separate from the data. I would like to have the dashboard be real time results...

Hi beginner here and I'm afraid I have myself in a pickle, I'm attempting to take a string from a single cell in one worksheet to a single cell in another, one character at a time, with brief pauses in between. Intending ultimately to give the user the animated effect of text appearing as if it...

Hi Experts, I want to download SharePoint 2010 document library's specific view only using Excel VBA where I have few filtered metadata columns. May you please help on this

Hello, I am very inexperienced at create macros but need to make one that will import all the text files from a specific folder. I tried using the macro recorder to do this but I'm not sure how to change the code so that it repeats the import process for each text file. Also I need the last...

Hi All, This code is getting my really angry at 11:57 at night! Can ANYONE shed any light on this? I don't think the use of my variable within the sheet is correct so potentially that's breaking it. Also, I'm getting a "End If with Block IF" Error message :( Can someone help? 'For each row...

Hi, I am really new to VBA and I have created a number of workbooks that Project Managers are required to complete and submit to a folder each month: M:\Business Change - Projects\PMO\JAMES - TEST\Demand Management\Resource Forecasts The only tab they are required to complete is the one titled...

Hey guys, I have a query based on visual basic coding in Excel. I am creating a user form for a piece of work, and there is a certain bit of the coding I am having an issue with. Here is my coding so far below: Private Sub cmdAdd_Click() 'Copy input values to sheet. Dim lRow As Long...

Hello- I've been searching forums all morning trying to find a way to find a way to get the minimum value using two criteria. Here's a sample of what my data looks like, and ideally what I'd like to see as a result. <tbody> Case # Size Date 1 Small 201501 1 Small 201512 1...

I have a short VBA macro that calls a sequence of 6 near-identical subroutines. I've provided one of them below (Year0) as a sample; the others just reference different rows on the same worksheet. If I step through AllYears it works fine to completion, but when I run it, it seems to skip the...

Hi, I have built a macro which loops through data from one sheet ("Sheet1") to build a URL (it's an API for the web analytics tool Webtrends). The macro then loads data from the API into a new sheet "display". Each dataset has the same 4 headers: Time Period, Page, Title, Page Views. My issue...

I have the following snippet of code which matches values from two arrays that are not indexed the same: For i = 2 To NumTrades For j = 0 To 2 * TheRange If Abs(ActCDF(i, 1) - TheCDF(j, 0)) < 0.001 Then...

I am using the following code to format the entry of time into a text field: Private Sub txtTime1_AfterUpdate() With txtTime1 If IsDate(.Value) Then .Value = Format(.Value, "HH:MM AM/PM") Else MsgBox "Input time as HH:MM" .Value = "" Cancel = True End...