Hi Aindril De, Thanx,it works,saving my time and, I am new to Macro,
But I could not do this, The shortcut Key for the above is: Ctrl+C followed by ALT + e + s + e then hit return (for transpose) Or You can consider creating your own shortcut key (one time affair and will always help you) On Thu, Jul 2, 2009 at 2:45 PM, Aindril De <aind...@gmail.com> wrote: > Dear Shivshankar, > > You can use the copy -> paste special -> transpose . > > The shortcut Key for the above is: > > Ctrl+C followed by ALT + e + s + e then hit return (for transpose) > Or > > You can consider creating your own shortcut key (one time affair and will > always help you) > > Create a macro that does what you want > (try macro recorder) > > and then assign a shortcut key combination to the macro. > > One macro that I use follows > Sub PasteValue() > ' > ' PasteValue Macro > ' Copy selection and Paste as Value Ctrl-Shift-v > ' > ' Keyboard Shortcut: Ctrl+Shift+V > ' > With Selection > .Copy > .PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ > False, Transpose:=False > End With > Application.CutCopyMode = False > End Sub > > Please let me know if this helps. > > Regards, > Andy > > On Thu, Jul 2, 2009 at 2:34 PM, shivashankar katageri < > shankarkatag...@gmail.com> wrote: > >> >> Dear all, >> >> Any one can help w.r.t copy from subjects of column cells to row cells,by >> just dragging or in no time, please >> >> for reference see attached file, >> -- >> Thanks & Regards >> >> Shivashankar.C.Katageri. >> >> >> >> > > > > -- Thanks & Regards Shivashankar.C.Katageri. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---