loops

Hello, First time poster long time lurker here! I have recently started getting into VBA and am struggling with a spreadsheet I am working on currently. I have a matrix filled out with either an X or an A in each cell (my rows are IDs and columns are Dates). What I want to do is, for each row...

Hi guys, i need help. i want to do copy-paste diffirent worksheet but with for next loop for example: Worksheets("Sheet1").Range("a1").copy = Worksheets("Sheet2").Range("a1").copy Worksheets("Sheet1").Range("a2").copy = Worksheets("Sheet2").Range("a2").copy etc... Sheet1: Sheet2 i have...

Hello, I am new to VBA and am learning as I go for a work project. I need to cycle through groups of data (anywhere from 1-319 lines long in a file with 155,000+ lines of data) and perform some operations on them. I am looking for recommendations on how to create a loop (looking at...

Hi everyone. I have a large excel sheet but interested in 3 columns with over 1,000 rows. e.g 1-1000 A B C 1 56 78 2 32 55 3 65 86 4 72 92...

Greetings All!! Introduction: I hope all is well. I am attempting to create a system where the user can log which date and time they will not be available to come into work. The day is a 24hr day, and there are 4 shifts within each day (presumably 6hr increments). I just want the user to...

Hi Everyone: Can someone please point to me in the right direction? My attempt is to go through a specific folder and consolidate all the files into one workbook. I am having three setbacks. First one is I am not sure how to loop through all the workbooks. Second one is adding the file name...

I started writing up a small inventory program in excel. I made one previously but the code is all messy, so i decided to rewrite it. I use a form for all user interaction. I ran into an issue where some of my code was running an extra 73 times. I looked and looked and looked, but the code is so...

I have multiple file paths detailed in a cell. The paths are separated by line-breaks (vbNewLine). I need to copy these files to a target. How do I loop through and for each file specified copy them to a single target?

Hi, I'm fairly new to vba so any help is appreciated! I have a macro that loops through 5 cells B20-B24, opens the files specified in cells, copies the data and stacks them in the main workbook. What I would like to include is if one on of the files in B20-B24 doesn't exist, for the code to go...

Is there any way to loop through the frames and cycle through the controls within them? I'm not as familar with frames as I thought... I'm trying to verify that data has been entered into my controls before going forward. the loop will highlight the requred controls and exit the code if a...

Hi, I need a macro that can change the value of a specific cell to all of the values in the rows beneath it, stopping when it reaches a blank cell. Each time the cell is changed, the spreadsheet needs to calculate (equivalent of pressing F9) before moving onto the next row. In my example...

Hello, I am running out of time and my head is spinning, so I hoped I would try this Forum for help. My VBA skills are pretty bad and this job is to complicated and to big to either use build-in macros, formulas or simply ctr+v What I need to achieve is: -Find names from a list in a table...

Hello again, I am just starting VBA and trying to practice loops. Can you please help me understand why this code works: For startingnumber = 1 To endingnumber If startingnumber = 1 Or startingnumber = 3 Or startingnumber = 5 Or startingnumber = 7 Or startingnumber = 9 Then...

Folks, in plain English right quick, here is what I am DOING and then I'll show the vba code for it: I have a Range from N2:AE2 > I want vba to autofill the forumulas in that range all the way down from 2 to row 198 Caveat, it is web scraping so it needs to autofill N rows every N seconds. I...

I'm trying to speed up my code. I understand there are many, MANY combinations that I'm looping through but want to know if there's anything I can do to help. Sub casey() Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual...

Hello - I'm extremely new to VBA, but have had to learn it at a relatively high level pretty fast, so forgive me if this is a simple question. There are lots of gaps in my understanding. I have been working with an equation that involves two levels of summation, see formula (a) below, but today...

Hi, I have a loop inside a Sub that copies and pastes values and cell names into a new workbook. Randomly, the loop stopped working. I haven't adjusted this code or any of the cells that it's looking at, so it's very strange. It's causing the Object error 1004. The code is below and I've...

I have about 125 files that are all identical in format, but they contain project information I would like to copy and paste in a master file. There are only certain cells I want to copy. When pasting the data to the master file, I would like each file to have it's own row. I had the project...

HI there I was wondering if someone can please help me. I have a services report that is generated every 6 months to capture whether service was delivered to the customer. I am trying to automate a manual process of outputting the results of undelivered service to the person's manager. I have...

Hi, I’ve got a problem here that is driving me INSANE!!!!!!!!! :banghead: I have 2 lists of ID numbers; one on a ‘master’ sheet and one on a ‘report’ sheet. I need to list all IDs on the ‘master’ sheet that DO NOT have a corresponding entry on the ‘report’ sheet. So far I’ve read the relevant...