Excel Data Analysis VBA Script

I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered.

Key Requirements:
- Prompt for target amount and range of cells
- Find combination closest to target sum
- Compatible with Excel 2016 and above

Key Features:
- Return the first closest combination found.
- No need to handle multiple valid combinations
- Prioritize efficiency for quick data analysis tasks

Ideal Freelancer:
- Proficient in Excel VBA
- Experienced with data analysis
- Able to optimize for Excel 2016

This is a crucial tool for my data analysis work. I need it to be efficient, accurate, and user-friendly.