Retrieving Data from Data Store

I have a great little Copy Paste Macro that Roy Cox wrote for me and need to take it to the next level. Currently, the data on WS Input is transferred to WS Data Store.

What I need is for the text box, within the Shape (i.e. the button on the Input_Screen WS), to change to "Retrieve Initial Case" and if pushed again, RETRIEVES the data from the Data_Store (i.e. RangeName: Case0) and replace the appropriate cells in the Input_Screen.

Roy, Spot on. However, what I was also trying to do is have the button change Text to reflect the status (i.e. if the Initial Case was stored, the Retrieve Initial Case would be displayed. Pressing the same button, the Initial Case would restore from the Data WS and the Text would reflect again, the "Store Initial Case" in the button box. That way there would be one button that would control the proper flow of data.

I'll go through the code and add mpre notes now I have a little more time.

0

Bright01Author Commented: 2018-03-03

Roy,

After playing with this for several hours to get the feel and logic of the code in order to scale it..... success! You are definitely making me a better designer and coder. You are a master. Thank you for the help. Just the way to start the morning.

I will be refining another question soon. Hope you will pick it up. My model is starting to "rock"!

Roy, About to send another Post. I have added additional rows to the original Range. HOWEVER, the new challenge is that I have other cells that are not in the same column that also need to be mapped into the Data_Store.