Is it possible when Excel Hits a certain point total in a cell that it can atomically generate a Warning Letter?

[Leicester City Fox]

Hi All

If a certain Cell hit a certain value say 10 point or over, is there away once this result appears in excel to automatically generate a fine notice for that provider with there details in other cells, Name, address?



Any simple ideas if this is possible or just a case of eyeballing the excel sheet and doing a letter and in word manually.

Many Thanks for your thoughts.

Leicester Fox

 

[CountTepes]

Use a worksheet change event.
The code will run only if 10 points is hit. If you want to send a letter every time more points are added then use Target.Value>10

Private Sub Worksheet_change(ByVal Target as Range)
If Target.Column= ColumnInWhichThePointsAre and Target.Value=10 then

'----Code here using target.offset(0,n) to access appropriate cells for name, address, etc.

End If

For code to populate a letter in word, straight from VBA look here.

Redirecting

answers.microsoft.com

Champions League 2021