vba loop

  1. D

    VBA Loop to create Excel Sheet, save excel sheet to specific folder on computer and generate Outlook 365 Email with attached excel sheet.

    Hi All I am hoping you can assist in how i would be able to writeup a VBA macro code that can resolve the below issue. Summary: Looking to create a VBA macro that can check the vins in the attached sample excel sheet “MOND94 – BUGS CERT -Checklist” where it will identify each row through a VBA...
  2. Z

    Vba Code if info in cell go to the next one and write something loop

    Hello all, I have managed to arrange a report with multiple changing data. After i set a filter on column L on N/A(items not captured in the original formula) i need to check for comments in column K, if there is a comment(some cells are blank), i usually have one out of 3 names there, so it...
  3. R

    Skipping rows in loop

    I have a macro that renames files based on the contents of two ranges. i.e 'Column A' contains the original name and 'Column E' will be the new name. When I run the macro it crashes if I haven't renamed an item in the 'Column E'. Is there a way to skip a cell if it is the same in both ranges...
  4. R

    Stop macro with loop then resume

    Hi all, I have a macro that I am running to pull a series of data into excel from an internet based API, which is then dumped into my database for further use. The challenge I am facing is that pulling the data takes a few seconds, and I need to stop the macro between changing the date and...
  5. W

    VBA LOOP SUM CONSECUTIVE NUMBERS

    I have a spreadsheet that I need to sum column L, if column J data is consecutive. If the reference is consecutive, they were most likely on the same order and I need to know the total of the order to compare to another spreadsheet. It would be nice if it went from A2 to the last column, but I...
  6. V

    VBA for looping GoalSeek based on If Then

    Hi Have been learning VBA for ~24 hrs, so apologies what may be a straightforward question, but I am trying to write a code for the following: I have the following rows of data in my sheet: Row 21 in my sheet is a row of binary flag that either equals 1 or 0 Row 35 is a row of input values...
  7. T

    Moving multiple records between worksheets

    I'm using the below to add data from a holding sheet(sheet2) to sheet1.The first record moves as planned. I need to run through all the records in sheet2 (not always the same number of rows) to sheet1. I've failed miserably with every "loop" "For...Next" etc. I've tried. I've only been able to...
  8. M

    Looping through a Column on One Sheet and Posting to Specific Cells on a Second Sheet

    I will try to simplify this problem so that maybe someone can provide an efficient solution. I am dealing with an accounting application that I created in Excel, and I cannot seem to get the data in the format that I need. The attached workbook is a simplified version of the application...
  9. Johnny Thunder

    VBA Help - Copy data from One Sheet to Another as a Loop - Excel 2016

    Hello, I am working on a project that will be looking at a datasource and trying to match up Model ID's onto another sheet in the same workbook and then copying over the Model Name if it finds the value. If not, it will look to the lastrow of the 2nd sheet and add the New Model ID and Model...
  10. P

    VBA Loop through named Ranges - Copy paste as values one after the other

    I have a workbook with several sheets that I have specified ranges for starting in A3 (same on every sheet) through column Q (row count varies). I have a sheet in the workbook that has all of the named ranges listed out in column A. I would like to write a macro that will look on sheets "Ranges"...
  11. H

    Looping an existing sub

    Hey everyone. I used a youtube video to modify a sub to help me track sent packages. It works perfectly for the first tracking number. However, I'm a little confused as to how to make the sub loop correctly down the "A" column to show results in the "C" and "D" columns. In the actual file, I...
  12. J

    Multiple Variable For Loop

    Hello, I've written thefollowing code to look at each cell in column C of Sheet2 that equals each cellin column C of Sheet1. Sheet1 values will show up multiple times in Sheet2, soI want it to loop until either there aren't any instances of the values matchingand column G being blank, or it...
  13. B

    extracting letters from words with variable length and adding a string to the extracted letters

    for example: can a word in a cell "star" be extracted into another cell as "s.mp3,t.mp3,a.mp3,r.mp3"? the words can be a of varied length .. the final output can be concatenated .. but the issue is that the words can be of any length .. example - "ant" or "butterfly" or "enlightenment" .. i...
  14. Spotycus

    Help with a VBA Loop with Nested If statement

    Hello, I have a very large excel sheet that uses a lot of VLookups Nested inside of If Statements and the calculation speed is horrible. Can someone help provide me a better way via VBA to accomplish the same goal? I recorded a Macro and added the formulas that are currently in the excel...
  15. B

    For Loop keep resetting itself after 58 iterations

    Hi I am having a problem i have never seen before and cannot work out why. I've searched for an answer but i've had no luck. I have a table of data 57 columns wide. Columns 1 to 8 contain information such as name and date etc. Columns 9 to 57 show "production" numbers; each column represents a...
  16. E

    Loop with two statements

    Hello everyone! I have got a excel file that looks the one below: Now I need a loop that check each cell in Column "H", if there is two cells in column "H" that matches each other (in this case Cell 1 and Cell 6). Check in Column "i" if there is any data in any of these cells, remove the cell...
  17. E

    How to add value to current cell,

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

    Instead of replace a number add.

    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...
  19. 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...
  20. D

    Filter and Replace Loop

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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top