Copy and Paste via message box

Got 6 columns. Column A is names. The names are repeated like maybe 10 "Johns" in a row. Then maybe 7 "Sam's" in a row and so forth.The number of times a particular name is repeated varies. Need a macro to read the name,bring up a message box and ask which row of "John" I want to copy and paste to sheet 2. Then go to the "Sam's",and complete the entire column.There are about 100 names.

Hi

Try

Please Login or Register  to view this content.

This assumes that the source data starts in row 1 and sheet2 exists. There is no error checking to make sure the row specified is valid for that name.


rylo

Works great.Thank you very much.