looping macro

  1. K

    Formula column number same as the row it reads from another column, through loop

    I have a sheet automatically created, depend on some condition I need to read the values on the column A, check with another sheet whether it exists , and print "Yes" or "No" on column D. The formula in column D is "=IF(ISNA(MATCH(A4,proj_req!F:F,0)),""No"",""Yes"")" How can I create a loop stmt...
  2. S

    VBA: Opening multiple hyperlinks to excels and copying data to a consolidation excel file

    Need I have a file where in column “C” I have a list of different hyperlinks to excel workbooks stored on SharePoint (number of rows and links is different every month, but approx. 140). I want to retrieve information from these hyperlinks (the information needed is all in one range on a hidden...
  3. L

    Loop through VBA

    Hi, I have two sheets. One having warehouse(18 warehouse) and second having shop (50 Shops). I need to map shops against warehouse within 200 KM. I have written one code for the same but need to loop it. Code is mentioned below Code will copy first warehouse from warehouse sheet and paste it...
  4. D

    Fetching and looping through a range ...

    Hi Everyone, I have struggling with finding an easy way to automate this process, but need some advise, as there is still some limit to my VBA knowledge. I have a calculator that works out prices which is a sheet in my workbook, and a list on another sheet in which i need to place the prices...
  5. P

    creating a macro that loops infor from certain cells to another sheet using a check box

    Hey, I'm trying to create a macro which inputs certain info from each row into another sheet. But i want to use check boxes so i can select certain row and that tranfres only that line Helpppp:(
  6. N

    Single ListBox Loop help needed

    Hi I have a worksheet with a single listbox. I need to loop through all the values in the listbox and make a PDF of the sheet. (The listbox items change all the values on the worksheet). I've searched and found some code that should work, but it isn't and I have no idea what is wrong. This is...
  7. S

    Deleting sheets based on a range

    Hi everyone. I'm pretty new to coding from scratch in VB, and I've got some code that should loop, but it doesn't. The idea eventually will be to download a spreadsheet, make a new sheet for every item in a range, and then filter for each of those items and put it in the right sheet. I have to...
  8. L

    VBA Looping through Worksheets and Calling Macros- Error 1004

    Greetings, I am trying to Loop through each of the worksheets in my workbook and call 5 separate macros on each sheet. However I am getting an error when I run get the "Run-time error '1004': Method 'Select' of Object'_Worksheet'failed" error message. Any ideas why I am getting this error...
  9. A

    VBA macro to extract data from one row to two rows

    Hi, I am trying to extract certain columns from a calculated row on a worksheet and generate two new rows derived from the original calculated row. Calculated data looks like this. <colgroup><col><col><col span="2"><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>...
  10. I

    Word Macro Looping Help-code inside

    Hi All, I found a macro code and was trying to modify it below, but I know I am missing a very simple way to loop what I want it to do, but not sure how. I am using this in Word and I want to ask a question of how many pages(times) to run this macro, then paste a picture we would be using to do...
  11. F

    hi i need some help with looping web querys

    take a number from colum A (001-650) paste it into a cell and then run a webquery the trouble i have is it won't loop this is the code Sub Macro2() Dim VAL As String Do ActiveCell.Offset(1, 0).Select Range("E2").PasteSpecial Range("E1").Copy Range("G1").PasteSpecial...
  12. S

    Looping thru URL

    Hello, I have create a marco that will go on a site and extract data. thru a web query. I would like it to keep looping through the column that has all the urls. and stop at the last row containing a url... SO.... Column K has the URLS starting at K2 these urls come in because a rss feed...
  13. P

    Looping in Excel 2007 Macros

    I need to set up a subroutine to make various calculations monthly whose totals then are placed in each year's row. It appears that Excel 2007 requires Visual Basic to do that, although if there is a simpler way to do that, please let me know that too. I set up a counter, so I believe that...
  14. N

    Loop thru Subdirectories find all .xls update value of specific cells

    Hello, I need code to loop thru all subdirectories open each workbook in the subdirectory that contains as part of the file name "_Sales Order.xls" and open each "_Sales Order.xls" and update worksheet "Sales Order Form" the following values: C44 new value = "00-440" D44 new value = " a few...
  15. A

    loop through sheet arrays

    i am having trouble working with sheet arrays. i have a relatively simple task of producing a particular report which gives our customers a snapshot of their stats for a week and then saving the file twice - once as is, and secondly with no links/formulas/etc (basically paste as values for...
  16. H

    Look up and return a name in the relevant row Loop

    Hi I have a Column A of mixed up names (the mix sometimes contains long codes), eg. 1234_treadmill* b812 bicycle ops+keyboard rf_treadmill- b812 bicycle_87 ops bicycle_&* mouse et.<33> And I have a Column B of simple names, eg. treadmill bicycle keyboard mouse I want a macro to go...
  17. B

    vba macro

    I have a workbook with 31 worksheets. One worksheet for everyday of the month. They are named 1,2,3,...29,30,31 I am having trouble writing a macro to do the following. In Range("k16") is a value on each worksheet. On the worksheet #2 i want to average the value of k16 of the first and second...

Watch MrExcel Video

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