VBA to load previous choices when a dropdown item is selected

[rtlane]

I have a dropdown menu. When a selection is made from the dropdown menu, I input information into specific cells (A10,A12,A14,A15,A16,A18,A20,A22,A24,A26,A28). So if I fill out information in those cells and then come back to that selection later, I want all the cells to load back up with my previous information. So obviously those cells would need cleared and loaded up when a new selection is made in the dropdown menu. It would be nice to do this by selection of the dropdown alone or I can have a load/save button that triggers the action.

 

[rtlane]

A lookup table with the stored values would be fine too

 

[rtlane]

Thanks anyway. This task must be more difficult than I though haha