I have a workbook, that highlights and moves data back and forth between tabs. Users asked for 3 new columns thus:
When double clicking into a row in Column A, I need the highlighting to extend to Column X now and not stop at U.
When the 'Move' buttons on either 'Master' or 'Retrieval' tabs are clicked, I need the content all the way to Column X moved now instead of it stopping at U.
Need the movement to not mess with the formatting either. It now hoses up my vertical lines too.
99% of code is done, just can't get over hump...Attached is my file. I got everything else working I believe, but can't figure out the actual moving of the data.