I want my users to be able to click on an Export User Data button that would then take ranges from two sheets and export them into a new file (which they could choose the name/location of) and then allow for them to import that data back in at any time.

My initial idea is to have a VBA code copy/paste those ranges from the two sheets onto a new sheet and then save that sheet in a new separate workbook. Then, when they import, have it create a new sheet with that data and run a macro to copy/paste it back to the ranges from the two sheets. However, I'm not sure how to really go about doing this in VBA and/or if there is a better method for such an idea.

I've researched this for the past week or so but cannot seem to find an adequate solution so any help would be greatly appreciated!