Hi All
I am doing this from home having spent the best part of the day
cutting and pasting data which I know can be done by VB but alas my VB
skills have never been good so any help would be brilliant!!!
I have a column of data imported from a text file with the start of
each line of cells numbered "Part 1" then 5 rows of data beneath then
"Part 2" followed by 4 rows of data, then "Part 3" and so on. The rows
of data all in Column A vary in size.
Is it possible to write a macro that will search for say "Part" find
the next then copy the cells to include the first "Part" plus cells up
to but not the next "Part" take this information to another worksheet
transpose it so that it is now in a row then loop back until there is
no more data to copy?

I have tried searching but have not had much success.

Many thanks in advance.


Mars