looping

I'm currently working on a macro for a client and it involves the use of looping. Essentially what I want to do is find every instance where "EERT OUPUT" header is mentioned in the spreadsheet then rearrange the stacked data below the EERT OUTPUT header into one line or row then proceed to the...

I'm trying to refresh data using a loop in VBA and aren't really sure how to proceed. Below is an image of what I'm trying to do. Basically I need to call out the country codes one at a time for use in a refresh with Hyperion Essbase. Once the data for a single code has been refreshed I want to...

Sorry if this is in the wrong place, I'm a first time poster. After a few guides I'm still having trouble doing what I set out to do. I'll start off with the basis on the spread sheet, so let's say in Excel, I have; <tbody> A B 1 Place BHX1 2 Date From 04/10/13 3 Time From 21:00:00...

I want a code where I have variables P_T1, P_T2 etc, and to be able to loop through them. I read elsewhere that the best way of doing this was to use arrays and I adapted code I found to give me this, but it is not working. Am I way off the mark? Dim P_T(1 To 4) As Variant Dim P_TChange(2 To...

I've been designing a userForm where the user can input a certain string into an Inputbox which will set off a load of Macros. The problem is that the Inputbox comes up multiple times depending on which code the user inputs. For example, if the user inputs 100H2102 it does it first time. If he...

Hi, I'm new to Excel VBA. I have almost done with 50% of the requirement, after that i'm not able to move further. Kindly someone help me out on this. Requirement: 1. I have a excel sheet to get the dependencies. 2. The rows and columns are dynamic, so i have a problem in selecting the range...

Hey guys/girls, My first post! I was originally trying to run this formula, but found that I couldnt autofill a filtered selection. heres the code: Range("I1").Select ActiveCell.FormulaR1C1 = _...

Hi Guys I'm relatively new to looping and im looking for some help. My problem is I want to loop an action based on the value of a cell (that value will change). Example: If Sheet 1 Range A1 = 10 Copy selection from Sheet 2 Return to Sheet 1, and paste selection 10 times (based on the...

I need to figure out how to write a macro that does the following: 1. Select the third sheet in the first workbook. 2. In the first workbook, set range j2 as the value to look for. 3. copy all of the data from the third sheet in the first workbook. 4. In the second workbook, search every...

I have 3 dynamic lists with some blank rows that I'm trying to go through and get only the common results (and no blank rows) but I have no idea how to do that. The data looks like this: <tbody> List 1 List 2 List 3 Revenue Revenue High value Device activation Competitors...

Hello All, I've got two functions(actually a lot more than that, but if I can get help figuring these out I think I can handle the rest),one to retrieve data from an SQL database and one to fill the data. Originally, I had it using a static range for date and times and then filling to a static...

hi trying to loop in two sheets to copy data over and paste it can anyone see my error little bogged down trying to find it, any help be appreciated? <code> Dim ProductID As String Dim MasIndex, MasLastRow As Integer Dim SwIndex, SwLastRow As Integer Sheets("Master").Activate...

Hi Guys, I have been puzzling over trying to create a macro for this. I am pretty new to VBA, and so this is probably out of my league in terms of programming :confused: I need a looping macro to take the first value from Q (i.e Q2), then search down the other values in column Q for its...

Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...

Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...

Hello! I’m a rookie VBA user and am having difficulties with a project.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have 3 worksheets in the same workbook entitled:<o:p></o:p> data <o:p></o:p> equipment<o:p></o:p> station<o:p></o:p> In...

Hi All, I am a noob to macros but have a need to get some data reformatting done that occurs often in my business. I start with this... -- removed inline image --- Basically, column b's quantities need to get moved to the row below it's associated barcode in column a I tried auto recording...

I am in the begining stages of learning vba coding for excel. I am trying to automate the creation of ~30 quarterly reports I have to generate each month. I have my basic code down that will generate a single report. What I cannot figure out is how to loop through this code, with each loop...

Hello. The following code scans through a worksheet and copies rows who's cells match "Yes" into a new worksheet. Can anyone please help show me how to modify it to scan through all of the worksheets in the containing workbook instead of just one? Thank you for any help. Sub SearchForString()...