for each

Hello all, Have a question that I thought I could easily answer but for whatever reason it doesn't seem to be working so another pair of eyes may help. I have a For Each Cell in Range Statement that looks at a Doc Type (2 Digit Variable) and when it finds "KR" to Search a Offset Cell for...

I have 2 lists of data and I need excel to go through one list and search for the contents of each cell in the other list and when it finds it, to then copy the cell next to it. I've started with... Sheets("Example").Select MyARange = "A1:A134933" For each MyACell in Range(MyARange)...

Hi All, Have a worksheet with a lot of data and I'm building a search VBA that hides/unhides columns based on 2 cells containing user entered data (from drop down menus). The first "For" function works without a problem, its easy since it's reading from a range with a single row, the second...

Hello! I am kinda stuck on something so I will explain what I am doing. I have a Form that looks kinda like a Web portal with 18 fields/dropdowns that a user can populate. This tool also has the ability to recall these fields if the user knows the tracking number, then all the fillable...

Hello All, I am working on a piece of code that loops through a range of cells and builds a Cell with data. I have the code working fine but I was not sure how to write the code in a way that I could have the code do 4 loops with varying column placement (C = #) . So as a workaround, I just...

Hello All, I have come to a spot in this code that I am not sure how to tackle. I will do my best to explain what the problem is, I have one code that is able to be triggered from 3 different sheets, the outcome for all three sheets is the same, the only thing that varies is the data that...

Hello all, I am working on a project and I have gotten fairly far with this and needed some guidance and possibly some revisions to my code to make it faster and shorter. Objective: 1. I have a Master Data Sheet (Ws2) that has 17 rows of data Columns("B:O"). Thru a loop on Column B, if the...

I imagine this is painfully simple, yet all my research and trying to figure it out on my own has led to failure. I've learned how to create a button in Excel and create code in VBA to have that button change cell values. The problem is that right now I only know how to affect one cell at a...

Sub test4opsgroup() Application.ScreenUpdating = False ActiveSheet.unprotect Dim cl As Object Dim l As Long, strCells As String Dim strpart As String Dim min As Range Dim numrows As Long Dim numcolumns As Long Dim partnum As Range Dim Qty As Range ActiveSheet.Range("T2").Select For Each...

I was thankful enough to receive a UDF from Rick Rothstein. https://www.mrexcel.com/forum/excel-questions/1101059-udf-sum-until-certain-column-not-blank-again-post5294214.html#post5294214 I was wondering if someone can help me and figure out a Do Until a certain range, I have to uses over 30 of...

Hi What I am trying to do is match a team name from a cell in range "B8:J8" with a team name on a separate page in the range "C2:C337". From those matches I want to determine the highest score and return that in a cell in range B20:J20 So for each team name in B8:J8 return the highest score...

Hello All, I am working on a project that has a summary sheet with some finance categories (see sample data below) using a matrix I have defined what Cost Centers and G/L Accounts​ are used to calculate the categories total. This is simple to do on a 1 cost center & 1 G/L Account basis using...

Problem: I have a Matrix of G/L accounts & Cost Center Variables. There is a possibility of 20 Cost Centers and 20 G/L Account Combinations for each of my Categories. 1. For each category, there are a 20 Possible Cost Centers as well as 20 G/L Account variations. 2. I need a way to...

I've created a license tracking excel for my company where we track what state our employees are licensed in and the expiration date. Since there are are several counties that require different licensing the list is fairly long (over 100 rows). I'm trying to write a Looping VBA that will hide...

Hello All, I am working on automating a Journal Entry Tool and could use some help with the last part of my tool. In need of code that will loop thru a range of cells and find a matching value to the Business Unit and log the cell.address in a sum formula. Full Description: 1. Column A is...

I'm sure I am missing something very simple, but I cannot get this code to work properly. For the purpose of this example, let's say I have a workbook with 10 worksheets, each worksheet named with a different color. I want to use an array of three worksheet names ("Red", "Blue" , "Green") and...

Hello All, I am working on a dropdown list that will create a formula thru vba to do a validation based on a dropdown list value true or false, true being the range needs to be added to my sum formula. Here is the dropdown list below, just need help with writing code to do this kind of...

Hello wise people of the internet. I'm tinkering with a code in VBA. It's purpose is to look at each cell in a given range. Part 1: Looking at the LEFT side of a string, it searches for "/56-Test1/" And it MUST be the first part of a string. Example: "A/56-Test1/AAA" should be ignored while...

I am currently trying to learn the basics of VBA and have been using the following code to work on a column of cells For Each foo In Range("A1", "A20") * Code * Next How might I return the cell being referenced at each iteration of this loop? For example, suppose cells A1 to A20...

Hi! I am trying to consolidate data from multiple workbooks into one sheet in workbook. For some reason, I cannot get excel to loop through those every sheet the workbook and copy the data. I am including my code below. Any suggestions would be appreciated! Sub BOCIndex() Workbooks.Open...