<div>
<blockquote>
I have large amount of data
</blockquote>
<br />
M82 : T82 is only 8 cells, not exactly a large amount of data. Please expand on how this is to be used for a large amount of data.<br />
<br />
Thanks<br />
Rob H
</div>


EE-AssignShortcutKeys2.jpg

<div>
All the chosen answers addressed the issue.
</div>


<div>
<div class="content wysiwyg-content">
I need values from column M82 : T82 to be pasted in the row L83 : L90. I have large amount of data to be pasted in this way. I tried some macros but tis not working.Can anyone help me?
</div>
</div>


I need values from column M82 : T82 to be pasted in the row L83 : L90. I have large amount of data to be pasted in this way. I tried some macros but tis not working.Can anyone help me?

Excel Macro for paste values as transpose

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.