Log In
Register
Home
June 26, 2016
Offline
Good day everyone from Maurizio
And my problem is this:
on an excel sheet in Cell (A2) I insert today's date.
While in the cd column (D2: D200) I enter the dates of other months or working days.
While with this Procedure, I would like to make sure that the letter (L) appears in column (P) corresponding to the same row only if the date entered in the column (D2: D200) is less than 5 working days
If not, do not write anything.
What I am trying the is not evaluating anything why.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
If Target = Foglio2.Range("A2").Value < 5 Then
Cells(Target.Row, "L") = "L"
End If
End If
End Sub
thank you for all the help you will be able to give me Greetings from A.Maurizio
June 26, 2016
Offline
Hello everyone, it's always me Maurizio.
I am writing to you again as on the one hand you no longer take into account my first reclamation as I managed to solve everything in this way:
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then If Target = Range("A2").Value - 5 Then Cells(Target.Row, "Q") = "D" End If End If
Therefore this is okay.
But if you could solve this enic but I'd be happier.
The Oriblema is this:
Still on the Excel sheet in the column (i2: i200) I insert many terms but when it meets the word (change balance) it should evaluate itself in the adjacent column (J2: J200) a number greater than Zero is reported.
Then it should put nice column (P) The letters (CS) that's all.
Thank you for all the help you will want to give me on this.
Greetings from A.Maurizio
Trusted Members
December 20, 2019
Offline
Can you add an example worksheet so we doint need to recreate the data
June 26, 2016
Offline
Hello Purfleet listen nop the moment I had not entered anything because in the meantime I was able to almost solve the whole.
Therefore, in order to be complete in all its parts, I would like to be able to solve this too:
I want to filter values higher than 25.000 and lower or = 100.000 which I insert in the Column (D2: D100) and the answer of the true or false should go in the Column (F2: F100) All I have tried alcube solutions; but they don't work
Thanks for all the help you will want to give me credit
Greetings From A.Maurizio
1 Guest(s)
