I need to create a routine to fill the remaining cells in a row with pre-set
values based on the change in contents (value) of a given row in column "A".
In the overall scheme of things, where does this routine reside and what are
best practices to follow.

Thanking you in advance.
Helmut