VBA / Copy range and transpose

[JulianD]

Hi guys, I'd appreciate a little assistance with this issue as my VBA knowledge is too little and I'm not having luck with searching and trying other people's code:

I've got a single column with over 11,000 rows of data. In it there are ranges of information that are identifiable because the first cell of the range contains the word 'edit (number)', and the last cell of the range says 'next' (and is followed by another 'edit' cell). The amount of cells between one 'edit' and 'next' is variable.

I need to copy each 'edit'-'next' range, transpose it in a separate sheet and repeat for the next row. How should it be done?

Thank you very much!!

 

[hiker95]

JulianD,

Welcome to the MrExcel forum.

I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com