Thank you @ballardw, as I was trying your approaches, and @DanH_sas came up with the answer for the first 3 points. For the 4th point, I decided to go with your approach of converting into a macro to create the desired range. Thank you for your valuable suggestions and time.