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.
Thank you in Advance!