Hi, i m serious freelancer with 100% completion rate and i believe i can help you to merge this 2 macros together. Basically we would loop through all worksheets in the workbook and apply those 2 macros (little modification are needed).
If you are interested, please message me.
Thanks, Milan