loops

Hello, I have a workbook that requires me to copy data from one sheet to another. The data I am copying is lifted from the original main page for analysis and possible amendments. I have been racking my brain over how to return this data if there has been any changes. My thought is that I...

I am extremely new to VBA, so please bear with me. I have searched the Excel forum but didn't see another question like mine (unless I'm not searching the correct terms). I have an Excel 2013 workbook with multiple tabs and I need to move data from the "TSA" tab to the "DRT" tab if the...

For the rows that have a "Yes" highlighted, I'd need to run a loop and scan the closing prices from the date and time of the "Yes" row beginning 6:30 AM if it's the Minimum for the "Oversold" columns and if it's the maximum for the "Overbought" columns. An example would be on cell P8. The code...

Hello everyone, I am not sure how to do this or even if it is possible. I have 2 sheets. First sheet has in A1:B4 a table where in A1:A4 is listed "Name" "Company" "Date" and "ID#" B1:b4 is where I fill in that information for the information i get. Then. B7 onwards I have a list of Brokers...

I have a macro that modifies an Excel file and pastes ranges into PowerPoint. However, it opens each file based on windows numbering system: 1 11.1 111.2 2 22.1 I need it to open the files in the order it is sorted in the folder as: 1 2 11.1 22.1 111.2 This is the opening code I would like to...

I'm not very familiar with looping, so can someone help me transpose multiple rows? I need this: <tbody> Name Prop1 Prop2 Prop3 Prop4 Pauline Papaya Pear Peach Plum Kael Koala Kiwi Kudu Kakapo </tbody> To become this: <tbody> Name Description Item Pauline Prop1 Papaya Pauline...

Hey everyone, So I will spare you some of the smaller details, but I am basically writing a code that cycles through all sheets in a workbook, looks for a specific range and then copies and pastes it to another sheet accordingly. The trouble part of the code right now is right at the beginning...

Good afternoon. I am brand new at Visual Basic. I have written a few simple macros but now I have something that is a bit more challenging and I am having difficulty. The primary worksheet of my workbook - let's call it 'sheet A' consists of 21 columns and 250+ rows. It has a column where the...

Greetings, I'm using excel2013 I'm using below code to select one specific item from the slicer (Slicer_Naam) this depends on the input from a dropdown list. (There's +600 options, that's why I want to use the dropdownlist with autoadding to be much quicker than the slicers) - If I understand...

Hi there, Trying to come up with a code that will loop an infinite number of times until the user enters a specific range of values. I can do it using 'Do While' or 'Do Until' loops but the assignment specifically mentions 'For Loop'. Please help. Thanks! Here is what I have now: Option...

Hi guys, I'm pretty new to coding but I need it for a dissertation on auctions. Any help is greatly appreciated!! A simplified version of what I am trying to achieve is to have a blank excel file with the number 10 in A1. I then want to run a Do Until loop with "A1 - 1" until it gets to zero...

Hello, This post is a follow-up to an earlier thread http://www.mrexcel.com/forum/excel-questions/916067-need-macro-calculate-week-ending-date-override-cell.html#post4404190. The working code below essentially overrides a user's data to input the correct week-ending date (Column H) and...

Geniuses, I am having a bit of trouble getting a piece of code to loop. I have a button that once clicked will do exactly this: If Duplicate_Find Is Nothing Then ActiveCell.Copy ActiveCell.Offset(0, 2).Select ActiveCell.PasteSpecial...

Hello, I am trying to update files of one of specific folder. I am using Do While loop to update these files. But I want to add condition. If in these excel files there is particular sheet with previous month name then loop should skip that file & move to next. I am not even amateur in VBA...

Good Morning! I have written a sumif sub that summarizes "value" based off of the criteria in the three columns to the left. <tbody> Year Contract type Price Range Value Year1 A Twenty > 19 Year2 B Fourty + 45 Year2 C Twenty > 15 Year2 D Fourty + 50 </tbody><colgroup><col><col...

Hello, First time poster here hoping if you could answer me a problem I have with an excel spreadsheet, I have a database with a lot of information (7 to 10k rows) so I can't do this thing manually. One fo the columns in the database is "year" and it, ideally, should go from 2004 to 2008...

Hi, I have a Word Form document with several Rich Text Content Control objects. I would like to write a program to go through the entire document and make a list of all the Content Control objects with tag names in it. I would like this list to be all of the tag names in the document. Finally...

I've tried performing this task with several combination of Excel formulas but to no avail. What I am trying to do is create a formula that loops through a START and a END dates. If the span contains a Sunday it will add one to the "Show Weeks." If it does not have a Sunday in that span it will...

This works but I know it's the wrong way. What's the right way to do this? I think I need to cycle through an array as I need to repeat this code for many lines.:confused: Public Orange As Long Public Blue As Long Public White As Long Public Green As Long Public Black As Long Public Red As...

I need a vba code for the following. If I have the below Column W is a concatenate function. 1 Column V Column W 2 -51474.79 3 -51474.79 4 0.00 1401 5 0.00 6 0.00 7 0.00 1402 8 0.00 9 0.00 10 0.00 1403 11 -563619.13 12 -563619.13 13...