Automatic input box to open if something is entered into Column D of worksheet allowing for the user to copy that cell then the input box to ask what range say O12-O16 (not always) to paste values only.
http://www.mrexcel.com/forum/excel-q...ml#post3715176
Bookmarks