Is there a process to accomplish excel automaticly highlighing trucks with due service every day with a pop up

[Relearning]

I saw Anthony47 and i think he could problably assist
I have spread sheet with several trucks that regularly we need to be update casue of mechincal sercives done to Tractors. I will attached the excel sheet to see if you could help me to either create an automaticly macro or or script that will notify me when the next vehicles are due for their service. Maybe opening another excel page or highlightinh and moving to the top of the page when are getting closer to 60 days from their last date I recorded their service. let me know if there is something you think could help me to accomplish this automated sheet .

Anybody's help will be appreciated

 

[Anthony47]

See my suggestion here: Excel VBA pop up message help

 

[Relearning]

I hope you can understand my knowledge is very limited and trying to make it happen will might not be ease but i will do my best to explain. Spread sheet name is 60 Dasy Tractor PMS. each columns is very similar but the one columns i really care about is D, lebael 60 Days. I have a list that cover three pages but if i can do this for few rows and columns i think i should be able to replicate it. what i just need is to use the warning option to warn me truck XX is almost due for service or close to 60 days in a secon page that pops on my screen each monirng so i can handle it first thing and schedule for outside company to pickup trucks and do service. Maybe highlight with a color and only those vehicles close to the 60 days

60 Days Schedule
TRUCK	Current Date	40 days	60 Day	ANNUAL
1000
1001SD	09/03/21	10/13/21	11/02/21	03/02/21
1002SD	11/15/22	12/25/22	01/14/23
1003AZ	08/24/22	10/03/22	10/23/22	09/24/21
1004	01/07/23	02/16/23	03/08/23	01/07/23
1005 SD	12/28/22	02/06/23	02/26/23	04/30/21
1006	01/07/23	02/16/23	03/08/23	01/07/23

 

[Anthony47]

Ok, let's forget about the other discussion

Which is the meaning of past dates (2021, 2022) in a sheet that (I understood) should contain dates of future maintenace?
Based on that example, which lines you wish to be highlighted?

 

[Relearning]

those are they days they were done last and they have not being done since i was not made aware so they are over due they went over 60 day

 

[Anthony47]

Not sure that I got your point.
Anyway, with the sample data and checking column "60 Days" I used in I10 the formula:

=LET(EarlyWarn,H1,TruckList,A2:E1000,NextDeadline,D2:D1000, FILTER(TruckList,((NextDeadline-TODAY())<EarlyWarn)*(NextDeadline>0)))

Having set in H10 10 (days) as the requested threshold I got the results shown in the following XL2BB minisheet

byLEXER_C30119_Registro formazione dipendenti_REV-Ant.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	TRUCK	Current Date	40 days	60 Day	ANNUAL			10
2	1000								1001SD	03-set-21	31-ott-21	02-nov-21	02-mar-21
3	1001SD	03-set-21	31-ott-21	02-nov-21	02-mar-21				1002SD	15-nov-22	25-dic-22	14-gen-23	00-gen-00
4	1002SD	15-nov-22	25-dic-22	14-gen-23					1003AZ	24-ago-22	03-ott-22	23-ott-22	24-set-21
5	1003AZ	24-ago-22	03-ott-22	23-ott-22	24-set-21				1005 SD	28-dic-22	06-feb-23	26-feb-23	30-apr-21
6	1004	07-gen-23	16-feb-23	08-mar-23	07-gen-23
7	1005 SD	28-dic-22	06-feb-23	26-feb-23	30-apr-21
8	1006	07-gen-23	16-feb-23	08-mar-23	07-gen-23
9
Foglio1

Cell Formulas
Range	Formula
I2:M5	I2	=LET(EarlyWarn,H1,TruckList,A2:E1000,NextDeadline,D2:D1000, FILTER(TruckList,((NextDeadline-TODAY())<EarlyWarn)*(NextDeadline>0)))
Dynamic array formulas.

 

[Relearning]

can you discribe steps how to put in cells. i am trying and i get nothing but errors

 

[Relearning]

ok looks like i made work found the following

So the goal is to use CURRENT DATE to let me know when the next vehiccle is approaching to their 60 days maintenance. and possible show them in another sheet just those vehicles highlighthed in red or yellow something that will stand out on my screen when it popsup

 

[Anthony47]

can you discribe steps how to put in cells. i am trying and i get nothing but errors

To test it, use the worksheet you shared and the same cells that I used for the demo.

When/If you get the expected result then move it to a different sheet:
-Select H1:I1, Contr-x (to "cut"), go the the preferred sheet, select the preferred posizion and select, Enter (to "paste")

If ii doesn't work, show what you get, explain why it is wrong