looping macro

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

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

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

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

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:(

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

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

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

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

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

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

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

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

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

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

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

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