vba loop

Hello People I have made following code. The code loop through all cells in a master file column "H" for each value(example H cell contains "Hello") , open a new file check if the value is equal to any of the cells in column "H"; if the value is equal(this case "Hello") take the value same row...

Hello people, The code does following: Loop through all Cells for every row in the Master file. for each cell open a Separate file Loop through all used cells in column in "H", If the cells are equal take the Cell same row Column "i"; paste it in the Master file to the same row as the first...

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...

I have one sheet with a Vendor column that has non-exact matches. (e.g. Walmart #6511 vs. Walmart #1654). I want to make all of those nonexact matches the same (Turn the example values into just Walmart.) I was not able to find a way to directly remove the non-exact matches. This led me to...

Hello all! I posted a couple questions about an ongoing project a while back. With the help of people here, and some modifications to the code, I now have a code which signs into the website specified in a certain cell, using user input boxes for username and password. The code will skip this...

Hi all, Is there a way to loop through a column(lets say A),where most of the cells are empty(size of the column will varying in length),but when the loop hits a cell that has data in(please see Fig1)the data is copied over to the adjacent cell in the next column.Any help appreciated:) Fig1...

<TBODY> Data_Tbl</SPAN></SPAN> Staff_ID</SPAN></SPAN> Department 1</SPAN></SPAN> Department 2</SPAN></SPAN> Department 3</SPAN></SPAN> City</SPAN></SPAN> Date Hired</SPAN></SPAN> Grade</SPAN></SPAN> Hotspot Level</SPAN></SPAN> ID1</SPAN> Marketing</SPAN> Analytics</SPAN> Core...

I have a data set that includes Column1 (Dates, week-to-week starting on Mondays), Column2 (product by SKU), Columns3 (product status, active... this will eventually be left out as soon as I finish the VBA to permit a list to be built allowing only active products to be selected in the data...

Hi Everybody, I have created a code that goes through all rows of a column and apply some conditions and create values in other columns, vode works fine but i want code to loop through other columns, see my code below here i loop through column C but after column C is done i want to apply same...

Hello, I'm hoping someone can help me out with this code. I'm new to VBA and trying to figure it out. I got the code to work for the first cell to copy down column A but can't get it to do the same for the next column of data. Any help is greatly appreciated. Here is my code, I've highlighted...

I have data in column A that I would like align right if =(LEFT($A10,4)=" ") is true. Is there a way with VBA to run through all of the rows in column A and apply the align right to all the cells that are true? Thanks for your help!

I'm trying to create a macro that will bold all text on a row if the text in column A starts with " [" then move down to the next row and repeat. Any suggestions? Example: Column A Column B Column C [501650 Dues] 123 456 Billboard...

Hi, I hope someone can help.. I would like some vba code to open a series of workbooks (based off a list of workbook names) and up date one tab (called raw data), refresh pivots, refresh formulae and close. I would like this to run until the list of workbook names is blank. Hope this makes...

All, I just learned how to create code today at my new job. Had no idea I would be learning code so forgive me if I make no sense. I created this code below to autofill data. After writing, I learned I could do a loop through my worksheets. Can someone help in where is should put my loop...

I I'm looking for a VBA loop that goes down column A and copies the first 7 cells to column C and then the next seven cells from column A to column D and so on. Basically what I'm trying to do is i have a list of data but i want to put them into column rows so they represent weeks. Thanks for...

Hi I'm trying to do a VBA loop for copying B6 pasting it to L4 and then copying K2 to C6, then doing the same again but copying from B7 pasting it to L4 and then copying K2 to C7 the bold numbers are the ones that I want to copy/paste next to after these would be copy from B8............C7 I...

Hello, I have a series of costs and I want to group them into X dollar groups (In the example below its 300). I have a much larger set of data then shown below and want to create an automated way of doing this because I will have to repeat the process with new data in the future. I am trying to...

KInldy support me get the loop as mentioned below using for next loop Thank you very much for support 1 1 1 2 2 2 3 3 3

Hello, Are there any Excel super stars that can help me? I have never written any VBA code, but I think I need it for the following: I wish to write a macro which has the following steps: (1) Goes to a sheet called "Price Data" (2) Copies a row of data (e.g. cells A2 to J2) (3) Puts the...

I have a built two macros--one that calls the other. The first one copys down the formula in the last row, then paste's the values of the last cell. This code works if I just run it on one sheet Sub CopyDownAndPaste() Dim Col As Range For Each Col In Range("C:U").Columns With...