Copy, transpose paste, and delete rows macro

Hello!

I copied some data (flight information) from a website to create a .txt file and opened it in Excel with tab and space delimiters. The data has imported so that it is all in the first column as a long list. My data is in blocks of 7 cells and I want to display each flight as a single row with seven columns.

I was originally copying the seven vertical cells, and then using paste transpose to make the row next to the first cell of the block. I then delete the six rows beneath the first cell and start again with the next seven rows. I recorded a macro of this and tried to play around with it to no avail.

I'm new to VBA so any help would be very much appreciated!

Thanks!

Please Login or Register  to view this content.

Sorry Buddy

I cannot help you until you insert code tags.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

If you are deleting rows it is best to start at the bottom and work upwards.

Otherwise your code gets complicated.

Please Login or Register  to view this content.