loop code in cell

Hi, I have a list of soccer games on sheet "Web Import" with team A in column C and team B in column E. I want to create a user from for a user to input scores for these games. So when the user form pops up (once the spreadsheet is opened) it should present the user with the teams from the...

Hi Everyone, first post. I'm generally "pretty good" with excel but I have no VBA experience. Hoping to find a solution to this problem without use of VBA. What I'm trying to do deals with dates, but for the sake of this I'm going to simplify it and I should be able to translate a solution to...

Hello, I have a list of shifts I did with the date. This list expands as I do more shifts. <tbody> A B 1 Shift Date 2 1 date 1 3 2 date 2 4 3 date 3 5 4 date 4 6 5 date 5 </tbody> I have another list of deliveries (on another sheet) with the shift given, I want to automatically...

Sub dataloop() Lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row For i = 4 To Lastrow If Cells(i, 3) = "Pass" Then ActiveCell.Offset(-4).Copy ActiveCell.Offset(2, -2).PasteSpecial End If Next i End Sub I am trying to use looping to copy and paste the value where C= Pass, then go...

Hi everyone, have a situation that I'm wondering how to loop the action to save me some time. I have 340 assignments, every 3 cells is grouped into a new assignment. Assignment1= Columns B,C,D Assignment2=E,F,G Assignment3=H,I,J My issue is that I need to copy/paste the formulas for B5,5C...

Hello everyone - I've got a cell with several words in it and I want to capitalize only the names: So, if I have a list with 3 names Greg Peter Bobby and my value in cell A1 is greg -play the guitar for peter and bobby I can probably do something like...

Hi there, Wonder if anyone can help me with looping the code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("I").Value = 90000 Then If Range("G").Value >= 90000 Then Range("K").Value = "Gold" If Range("G").Value < 90000 And Range("G").Value >= 70000 Then...