Hi. I have a source worksheet with 8 separate datasets. I want the user to be able to indicate which of the 8 datasets they want to copy/paste from this source worksheet into the destination worksheet. I can write a macro that will allow the user to indicate one, several or all eight of the datasets and then bring the user to the destination worksheet so that he/she can click on which cell to paste each dataset into (note: I will actually use .Value=, not copy/paste). But what I'd like to do is have the user select their 1-8 desired datasets from the source worksheet and then, upon activation of the macro, a menu will come up with 8 radio buttons (laid out in the formation of the 8 destination ranges). The user could then click which radio button they want the data sets pasted into. Further, it would be great if the radio buttons were NOT selectable if there is already content in the particular destination range. Thank you in advance for any thoughts.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
