two excel vba small programs

Good day

i have two excel vba programs

that i need very quickly

please make sure you can do them and submite them before time

if you can't (((( do not take this hw )