loop

Hi, I'm trying to analyze many workbooks (formatted exactly the same) and place the analyzed data into a new master spreadsheet. How would I write a VBA macro to take an avg and stdev of a range of data for each workbook in a folder...they are labeled in the fashion "Myworkbook__00#" # being...

I want to filter and split the data based on branch name (Branch List sheet), and also want to save that new excel workbook for each branch as per the same name as mentioned in the Branch List sheet. Please help me with LOOP function to complete my code.

I'm trying to write some VBA code that will tell me if a row containing exact data exists. The table (Table1) is formatted as a table with headers, and has 20 columns; the first three columns are what I am concerned with right now. - Some projects will have multiple associated sites - Some...

I have text files that may have one, or multiple, instances of the following line groupings: PG27FANU1022356 PG2803110701 PG30A0331202412002 2809...

I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 Loyal etc... The user will be able to put a number in a cell and a different cell will...

I want to create a VBA code that pastes different columns within a row to a pdf, then move to the next row and do this to 30 different rows. Then I want it to save the document then continue from where it left off. Therefore, after 30 rows have had their columns pasted into the text boxes within...

The worksheet in question is NOT a table. Some of my fields are merged and I am fully aware that I need to unmerge to copy/paste then merge after the code runs. My worksheet contains two sections which are restricted to a set number of rows for data entry. 1) Responsible Party Analytical...

hi, need macro to open and copy data from multiple txt. files (exactly i need direct 35 values(years)) to excel. I did macro for one year, but im struggling to do it for 35 years, can someone help me with solution please? Sub txt_to_excel() Dim X As Double Dim TXT As String ' Adresss Open...

Hello, I have a macro that does what I need it to do but if there is a blank cell it deletes it also. How do I add into this code a loop to ignore blanks? <>"" Sub DeleteDuplicates() Dim Rng As Range Dim SRng As Range Set Rng = Range("B3", Range("B3").End(xlDown).End(xlToRight))...

Hi everyone, I would like your help on figuring out an issue I am facing. I have built a macro, where I need to format the source data and map it and transfer it to a template. One of the fields I have to map requires that I put an underscore and a number after the record, the number being the...

On a user form, I have 2 sets of 25 text boxes and 1 set of 25 checkbox named TextQty, TextPrice, CheckBox respectively. I am trying to pull the checkbox caption and the values inside the textboxes into a listbox if the checkbox is selected. I want to be loop through each set of the textboxes...

I currently use the code below. I now have data in column H, so I have changed the range part to Range("A2:H3001"), as I want to iterate numbers in column H, too. However, this column contains different formulae in the rows, and I only want the script to iterate the number every 3rd row in each...

This code needs to delete any table rows which are next month. The Dims etc. are correct so i can`t workout why it`s not depleting the next month lines ?? With tblDailyMail.DataBodyRange For Rw = .Rows.Count To 1 Step -1 For Each Cell In .Range("A2:A" & LRow)...

It's been awhile since I've created this macro and I'm having trouble. I have a workbook "Sales" with a worksheet "Names" that has 100 names starting in cell A1. I want to copy the name in A1, paste into a new workbook (it updates a bunch of figures), and save that workbook under that name. I...

Hello, I need a loop VBA code to show all data from every worksheet on my workbook. The workbook is called Consolidated. I want to keep the filter so I can refilter later. Also, can you help with a loop code to refilter every worksheet as well? Thank you to anyone who can help me.

Hello All, I need a script that cycles through all the sheets in a workbook and adds 2 (or more) columns at the end of the table of each sheet (except the first sheet). In this case I have a YES and NO column to be added. The added columns YES and NO need to be autofilled all the way down to...

Hello, I am looking to create a loop to run through all the worksheets in my workbook to run some code that clears the contents of "blank cells". The code works for the active worksheet but doesn't seem to run through the loop to the next one. Sub WorksheetLoop() Dim ws As Worksheet For Each...

Hi So, I have a macro that is repetitive with the only change is the name being searched. The macro works but I am limited on the number of names because I get an error message saying it is too large. Can someone help on condensing this maybe in a loop (not sure how to do that) Private Sub...

Hi I'm trying to color shapes from the filling background of several other cells (themselves located on another sheet than the shape). The shape "Pa1" (located on sheet "gif") would successively have the color of cell A1, then cell B1, then C3, then A2, then B2, then C2, then A3, B3, and C3...

Hi all! Stucked with adjusting a code that sums my hours. I use two codes to get the value of the sum hours. The first one checks if both cBoxes are set, the second one is called after the check for making the sum of the hours. The looped list is on the second worksheet. The dates I'd like to...