Auto Update data weekly help

[gillmit]

Hi

I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on the 31/05/2024 i have to change the red box (Cell B2) to say 8% the previous weeks remain the same(7.5)% and the following weeks after carry on auto updating on the new 8%.

Any help would be much appreciated

 

[eiloken]

Hi

I am stuck and need some help please. I have attached a picture of the issue i am having. Basically i have 7.5% in the red box (Cell B2) that i have to update manually. I would like it to auto update each Tuesday of the month with the same % as the week before (orange box's) but if say on the 31/05/2024 i have to change the red box (Cell B2) to say 8% the previous weeks remain the same(7.5)% and the following weeks after carry on auto updating on the new 8%.

Any help would be much appreciated

Insert this code to worksheet module that include your data:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim i As Long
    Dim cll As Range
    i = Range("B" & Rows.Count).End(xlUp).Row
    If i < 7 Then Exit Sub
    For Each cll In Range("B7:B" & i)
        If IsEmpty(cll.Offset(, 1)) Then
            With WorksheetFunction
                If .Weekday(Date) = 7 And .WeekNum(Date) = .WeekNum(cll.Value) Then
                    cll.Offset(, 1).Value = Range("B2").Value
                End If
            End With
        End If
    Next cll
End Sub

 

[gillmit]

Thank you so much for the info. I am still struggling though. I need to make it happen for multiple cells

I have attached a screenshot of what i am looking to do.

cell C3 for example needs to update C95 then C96 and so one. 1 updates 1.. 2 updates 2. Can you help please

 

[eiloken]

Thank you so much for the info. I am still struggling though. I need to make it happen for multiple cells

I have attached a screenshot of what i am looking to do.

cell C3 for example needs to update C95 then C96 and so one. 1 updates 1.. 2 updates 2. Can you help please

i saw that new value need to update in range E4:E12, but i don't think we need that column, why just use column C for update value?

 

[gillmit]

i saw that new value need to update in range E4:E12, but i don't think we need that column, why just use column C for update value?

Apologies there is another 1-9 below

so C4:C12 updates the data underneath as pictured. E4-E12 Updates another row of 1-9 data not pictured if that makes sense. will send a new picture

 

[gillmit]

Apologies there is another 1-9 below

so C4:C12 updates the data underneath as pictured. E4-E12 Updates another row of 1-9 data not pictured if that makes sense. will send a new picture