Hi there,
I have 2 excel worksheets open in the "tile vertical" view (therefore I can see them both side by side), from 2 different workbooks and I want to drag & drop by selecting either a single or multiple row off 1 worksheet and drop into the worksheet of second workbook.
I don't want to copy and paste, I want programming code that will enable me to drag and drop from one worksheet to another. The catch is that no matter where I drop the selected data from the 1st worksheet into the next, the data must always retain its numerical order positioning.
For example if item 1 of worksheet 1 has a code of 005.010 - 0010, and worksheet 2 has an item code with 003.005 - 0001, then the positioning of the worksheet item 1 once its dropped into worksheet 2 must be located after 003.005 - 0001, because 005.010 - 0010 numeric order is greater than 003.005.
Start Free Trial
