No ... nothing manual.

The bolded, key terms I listed are used in VBA Coding. Creating macros that utilize these terms will automate the functions you are seeking.

And ... there are plenty of complete example code you can simply copy and paste into your project.