How do you drag a column from one sheet to another? (Not copy and paste)
How do you drag a column from one sheet to another? (Not copy and paste)
To the best of my knowledge, you cannot drag/drop to other sheets. Instead, try cut/paste...unlike copy/paste, it moves the data, and maintains all links to and from those cells
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Highlight the column, click the selection border and hold, press alt and hold, then drag and drop on the desired sheet! PLUS: once you hit the sheet tab with your cursor, you can select where the column will end up by moving it ON to the sheet. Easy as 1, 2, 3! Hope it helps!!!!
Add reputation if all works out okay, please.
Thanks.
Last edited by Lennnny; 12-16-2013 at 12:57 AM. Reason: More info
Unless I am not understanding your directions, that doesnt work
Yes you can do it as suggested by Lennnny![]()
Last edited by :) Sixthsense :); 12-16-2013 at 01:32 AM. Reason: Taken Back My Previous Opinion After Some Testings :)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
OK cool, I guess I must be doing it wrong then![]()
@ FDibbins,
Just wanted to show how I got it working
Please refer the attached screenshot![]()
OK duh, thanks 6...I was clicking on the B, instead of hovering just below it until the 4-way arrow came up!!
Not a problem!!! Just happy I could help :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks