Macro to sort clipboard Paste all function

[Closed]
Report
Posts
3
Registration date
Saturday December 22, 2012
Status
Member
Last seen
December 29, 2012
-
Posts
3
Registration date
Saturday December 22, 2012
Status
Member
Last seen
December 29, 2012
-
WINDOWS 7 EXCEL 2007
Hello, I would like to make a macro that would convert the data below to (See-Below)

LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £336 77 105 --
Hurdle 9 1 1 0 £1,976 £2,803 97 99 99
Rules Races 13
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 19 0 2 1 £0 £1,795 53 60 48
NHF 2 0 0 1 £0 £300 2 98 --
Hurdle 16 2 1 2 £4,330 £5,972 98 105 99
Rules Races 37
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 9 0 1 2 £0 £1,791 50 62 47
Hurdle 35 4 3 6 £11,282 £18,747 102 109 98
Rules Races 44
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £95 53 92 --
Hurdle 7 1 0 0 £2,082 £2,365 94 107 97
Rules Races 11 1




TO THIS ONE BELOW

LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £336 77 105 --
Hurdle 9 1 1 0 £1,976 £2,803 97 99 99
Rules Races 13



LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 19 0 2 1 £0 £1,795 53 60 48
NHF 2 0 0 1 £0 £300 2 98 --
Hurdle 16 2 1 2 £4,330 £5,972 98 105 99
Rules Races 37


LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 9 0 1 2 £0 £1,791 50 62 47
Hurdle 35 4 3 6 £11,282 £18,747 102 109 98
Rules Races 44



LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £95 53 92 --
Hurdle 7 1 0 0 £2,082 £2,365 94 107 97
Rules Races 11 1

BLANK ROWS TO BE INSERTED ABOVE LIFETIME RECORD SO THAT IT (LIFETIME RECORD)IS 7 ROWS APART
ROW 1,8,15,22,29 ETC
LIFETIME RECORD IS SITUATED IN COLUMN A
ANY SUGGESTIONS
MANY THANKS
STEVE

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you please upload a sample workbook at some public file sharing site like speedyshare and post back link to the file back here. It is hard to see how the format is and how do you want it to be. In a sample book it would be easy to see
Posts
3
Registration date
Saturday December 22, 2012
Status
Member
Last seen
December 29, 2012

Thanks for quick response I have posted the same Macro problem on
https://www.excelforum.com/excel-programming-vba-macros/886056-macro-to-sort-and-insert-rows-help.html#post3057000
Many thanks again
Steve