Copy 2 specific Sheets, specified range, paste as values to a specific folder

I have repeating process where I have to follow, I really tried to write the VBA but I cannot match your expertise.

I have a file that is called Master Volume FY2022.xlxs, it has a lot of sheets but I only gave you the two in question. My process is as folly:

1. Copy Final Charges - 2022 Load and Final Visits - 2022 Load into two SEPARATE files.
2. For Final Visits - 2022 Load I only want B1:Q708 or the end of data as we may add remove rows
3. For Final Charges - 2022 I only need C1:Q351 or the end of the data as we may add remove rows
2. Paste as Values, as both of these sheets have formulas
3. Save both separate files in the following location J:\FI\MPG\FY2022\Volume\Loads
4. Save Final Visits - Load sheet as Vists and Todays Date.xlsx
5. Save Final Charges - Load sheet as Charges and Todays Date.xlsx

If someone can kindly help me so I can learn the process it would be great.
Thank and I hope you have a great day.

Bo_Ry Thank you very much, you always help me so much and I really really appreciate it.

Can I please ask you a favor? I am struggling with this as well, this one is very time consuming. I know this is obnoxious but can you please also take a look at my other post to see if you could provide any help?

https://www.excelforum.com/excel-pro...ml#post5466024

Bo_Ry I am getting an error with this code Run-time error '1004': Method 'Close of object'_workbookd' failed