-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vba loop macro
-
N
Lock column ranges based on value in header row, loop through all
Hi, I need some help getting this macro to loop. I have a Budget Forecasting workbook with about 40 sheets and I need to unlock cells where the final users will input projections. Below is a snip of the ranges involved. If the value in Row 6 of the column is "Projected" then the cells in rows...- Nic2
- Thread
- macro - all sheets macro - lock cells vba loop macro
- Replies: 1
- Forum: Excel Questions
-
P
VBA Loop through Range copy paste values on another sheet
I am trying to write VBA to look through a range I have titled "Programs" which runs from column BH2:DY39. I am trying to write a macro that will look through each record of 37 project codes and look for a Y in the row. If there is a Y, then I need the macro to copy the project code from coumn...- pthomas416
- Thread
- copy excel excel vba range vba loop macro
- Replies: 16
- Forum: Excel Questions
-
C
VBA for a multiple GoalSeek on three rows
Hi all, That has to be dead simple but I can figure it out (a beginner!). I have three rows: 5, 12 and 19. my columns run from L to BM for all three lines. What I need is a loop that does this: Range("L5").GoalSeek Goal:=Range("L12").Value, ChangingCell:=Range("L19") .... but for the...- Chocho123
- Thread
- vba goal-seek vba goalseek vba loop vba loop macro
- Replies: 1
- Forum: Excel Questions
-
K
Excel VBA Scraping IMAGES from an HTML data table
I have an HTML data table on a website, and have set up a code to scrape all of the data from it. HOWEVER, it does not scrape the images in this HTML data table. I want to scrape the images and have them go in their associated column of their associated rows. If I cannot scrape the images, it...- Kc7487
- Thread
- data table html scrape html table images vba loop macro
- Replies: 8
- Forum: Excel Questions
-
M
Need a macro that populates statement based on the header
Dear Team, Need a macro which will create a statement based on the header information dynamically and iterate till the last row in the data in excel. Header information wont be static all the time. It changes all the time :) <tbody> emp ename dept 10 kiran 50 20 shiva 30 </tbody> Need...- m_kiran
- Thread
- vba & excel vba concatenate vba insert function vba loop macro
- Replies: 2
- Forum: Excel Questions
-
F
VBA- running loop wihin another loop
Hi guys, I have a problem. I need to copy some 500 files into one. I think I have to do two loops. First loop is correct I guess, I just open and select these files. I have a problem doing second loop. The problem is that the sheet I want to copy changes name every time, but dont know how to do...- flashjas
- Thread
- vba loop macro vba loop within loop
- Replies: 10
- Forum: Excel Questions
-
N
VBA using Excel's MATCH/INDEX function
HI there I have 2 sets of data and the only unique identifiers I have in both data sets is: FirstName LastName DOB I am trying to match on these 3 criterias and also return their Address, Suburb, State, POst Code. This is a very large data set and I am only expecting a small amount of matches...- nvdunn
- Thread
- excel index & match vba loop macro
- Replies: 5
- Forum: Excel Questions
-
L
Problem with looping a certain VBA sequence
Hi guys! I'm having trouble looping a certain macro that I just coded. My main goal is to search some information in a text file and then having the output result in excel columns. The bit of code I've came up with so far works great but I can't get it to loop in order to search the whole text...- lsebe2
- Thread
- vba loop macro
- Replies: 1
- Forum: Excel Questions
