Exporting Multiple Ranges In A Way That Allows for Re-Import

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!

Thanks! The restore() one doesn't seem to be working for me (it runs but the data stays the same in the initial sheet). Also, is there a way to have it prompt the user to choose their own save location for saveranges() and then have the user browse for a file to "restore" in restore()?

For those curious, here are some tweaks I ended up making to achieve the idea that I wanted:

Please Login or Register  to view this content.