Is there was a way to create a macro that copies selected cells in a row, paste the copied cells into a set number of rows below that row of selected cells, move to the next row following the pasted cells and repeat the process of selecting the cells from that new row? I need to do this both for selected rows and transposing selected cells in a row. I have provided the macro created by doing this manually over and over. Hopefully there is an easier way.
'****copy and paste into specific number of rows
Please Login or Register to view this content.
'*****this one is transposing
ThanksPlease Login or Register to view this content.
David
Bookmarks