VBA code for 2 buttons that can clear cells in a row then second button to bring data back

Hey BanginmyHeadOnMyDesk,

1) When you click Clear the first time will it remove the first column of data, second time the second one etc.?

Answer: Correct, 1st click removes Row 5 Data, second click removes 6 row Data, etc....

2) Clicking Retrieve should bring them back in the reverse order of how they were removed?

Answer: Correct, so if i click Clear 99 times, i am going to have to click Retrieve 99 times. That is the best part of the whole process. exactly what i want to have to do... BUT.... Upon exiting the workbook, the VBA will retrieve all the data back to its original state.

3) Do they need to be removed or could they just be hidden?

Answer: So the possible tricky part.... I would say Removed or Replaced actually.

Explanation: I have other cells referencing Row 5.... Row 5 is the "Key" Row and the cells that are referencing it are in other sheets so..... in all reality, when the user clicks the "Clear" button, VBA will retrieve all the data starting at Row 6 and below then paste it over the top of Row 5's data... The result after one Click of the clear button: Row 6 data is now in Row 5. All the data gets bumped up one row and the original data that once was in Row 5 is now gone UNTIL the user clicks the "Retrieve" button, then VBA pushes all of the data back down by one row and the original Row 5 data is back again. So there always has to be data in Row 5..... Make sense? Then as a reminder, when the user exits the workbook, VBA will ensure all data is back to it's original state as if the "Clear" button was never clicked