I was able to create a macro and assign it to a button that would allow me to use the cursor to highlight a cell then click the button to have the values of that cell be copied, pasted into a different cell, then delete the value in the original cell. What I would like to be able to do is highlight multiple cells within the same column using the cursor, click the button, and have all highlighted cells be copied, pasted, and deleted. Here is the code that works for one cell.
Suggestions?![]()
Please Login or Register to view this content.
Bookmarks